Mud-club
Chat & Social => The Bar - General Chat => Topic started by: TDi90 on December 06, 2007, 13:26:44
-
:oops: the most annoying thing is i did a level computing!!
but does anyone know how to add some cells up in excel.
i am struggling, and i dont think its because i dont know how to do it i think its cos im going wrong somewhere.
i have antered numbers into cells A6 and A7 and A8 and have declared the cells as NUMBER.
now in a seberate cell i have put this equasion: =A6:A8 (i also tried: =A6+A7+A8 still wont work)
but the answer wont come up? :?
any ideas anyone?
this is really poor of me i know :evil:
Rob
-
=sum(A6:A8)
-
ahh yes thats the one....
thank you! god how embarressing....
Rob :oops:
-
Confused - =A6+7+A8 should have worked... :-k
-
Confused - =A6+7+A8 should have worked... :-k
You need the SUM command otherwise it won't know what you're asking it to do. Could also be COUNT etc.
-
Don't be embarressed I don't even have a clue what you are talking about!! :lol: :lol: :lol: computing I am just getting into it all, and have discovered Ubuntu/Linux and I am running my pc on it instead of crappy Windows. I have learned hell of a lot, from just trying stuff. and my pc work hell of a lot better now. and it's FREE!! :D :D :D
Just thought I would share that with you,because I am so chuffed with myself for managing to set my pc up on Ubuntu and getting it to actually work. BETTER :shock: :shock:. Sorry. :oops:
-
well done fasthands!
its just i actually did computing/IT for 5 years :oops:
and then after not doing it for 1 year i forget lots of stuff :oops: :roll:
-
Confused - =A6+7+A8 should have worked... :-k
You need the SUM command otherwise it won't know what you're asking it to do. Could also be COUNT etc.
Rubbish! :shock:
Unless it's Excel 1.1 from windows 3.1!!! :lol:
Just tested it for completeness... "=A6+A7+A8" should have worked.
-
Isn't there a 'function' button at the top listing the main calculating functions?
-
bum, your right. you can do it either way. but with sum its a little quicker :)
-
Highlight cells, pick your new cell and click the SUM button? Simple ....
-
It feels great to be liberated from Windows, it's Overpriced rubbish!!!
And I feel like a computer buff, Yea!!! :lol: :lol: :lol:
-
Next steps........
Goal Seek?
Conditional Formatting?
Look Up Tables?
:twisted: :twisted: :twisted:
-
Next steps........
Goal Seek?
Conditional Formatting?
Look Up Tables?
:twisted: :twisted: :twisted:
i can do those... apart from goal seek....never heard of that :?
Rob
-
It feels great to be liberated from Windows, it's Overpriced rubbish!!!
And I feel like a computer buff, Yea!!! :lol: :lol: :lol:
It is good, isn't it? I've seen Linux improve dramatically in the last few years. I bought a copy of Red Hat (you pay for the disks and manuals) ages ago, it was pretty dire, but then I went over to Mandriva in '06. Upgraded to '07, still no problems, now I'm trying to find the time to go to '08 (takes a while to install and configure). Hopefully my floppy disk drive will work again with the new version...
-
Rubbish! :shock:
Well that told me then :? - you have such a way with words.
-
Rubbish! :shock:
Well that told me then :? - you have such a way with words.
:oops: :wink: :lol:
No offence meant... enthuisiasm getting the better of me...
I'm sorry... :smack:
-
Rubbish! :shock:
Well that told me then :? - you have such a way with words.
:oops: :wink: :lol:
No offence meant... enthuisiasm getting the better of me...
I'm sorry... :smack:
Spot on Ski !
-
i can do those... apart from goal seek....never heard of that :?
Rob
"Goal seek" is usually used in a spreadsheet with multiple variables to do sensitivity analysis e.g.
maybe to vary something like interest rate to meet a certain level of profitability. You'd say set profitability to the required %age, by changing the variable "interest rate".
Goal seek should then find an answer for you!
-
Ah Linux, certainly has improved recently. I remember the first time I had a go at using Mandrake, must be nearly 8 years ago. Actually downloaded the 2 isos on my 56k dialup connection! Then there were the joys of trying to get it up and running, main problems were with the onboard graphics and sound. And of course no internet, as it was a winmodem!
Tried Ubuntu about 18 months ago I think, and things have certainly improved since my first forays! Installation is a much simpler process these days, and the amount of supported hardware has vastly increased.
-
bunch of computer geeks...........
why thank you my coat :lol:
-
bunch of computer geeks...........
why thank you my coat :lol:
armour-piercing rounds anyone ? ? ? :wink: :lol: :lol:
-
Whats his coat made from :?
-
Whats his coat made from :?
knowing Mr PUXLEY it'll be the bullet proof type :twisted:
-
Whats his coat made from :?
knowing Mr PUXLEY it'll be the bullet proof type :twisted:
"Gunner, load sabot!"
"Sabot up!"
"Target, 200, coat, leaving forum"
"ON!!"
"Fire"
Kerrrrboooommmmm!!!!!!!!!
"Target destroyed"
:(biglaugh):