Chat & Social > The Bar - General Chat

i never thought i would ask this.... (excel help)

(1/5) > >>

TDi90:
: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

Lucy1978:
=sum(A6:A8)

TDi90:
ahh yes thats the one....

thank you! god how embarressing....
Rob  :oops:

hodgei:
Confused - =A6+7+A8 should have worked... :-k

mike142sl:

--- Quote from: "hodgei" ---Confused - =A6+7+A8 should have worked... :-k
--- End quote ---
You need the SUM command otherwise it won't know what you're asking it to do. Could also be COUNT etc.

Navigation

[0] Message Index

[#] Next page