Adding random cells togethr

[Guest]

I want to be able to add
y2,aa2,ac2,ae2,ag2,a12,ak2,am2,ao2,aq2,as2,au2,av2,ax2,az2 together and
return the result in bb2

I am using =sum(y2,aa2,ac2,ae2,ag2,a12,ak2,am2,ao2,aq2,as2,au2,av2,ax2,az2)
however I only see the actual formula returned in the cell not the result. I
have been able to do this in the past. Can anyone help with this problem?

 

[L. Howard Kittle]

Hi Kaylean,

Perhaps BB2 was formatted as text before you entered the formula. Select it
and hit F2 and Enter.

HTH
Regards,
Howard

 

[R..VENKATARAMAN]

tools-option-calcualtion
is the calcualtion automatic or manual

 

[Guest]

Yes.


Insure that the cell is formatted as General before entering the formula
into it.

The SUM() function can hold up to 30 arguments, so you example should work.

 

[Saruman]

The text argument is probably correct. Cells formatted as text, usually only
show a formula and not its result.

Change to General and possibly need to either, hit F9 or double click in the
cell and then hit enter to activate the formula.