Sum up individual cells (not a range)

[Japster]

Hi Everyone,

Having some problems and I'm hoping someone here can help. I've done some searching, but I can't find my issue...

I have a spreadsheet with a number of "If Statements" that return blank if there is no value. What I am trying to do is sum up the values that appear when the cell is not blank. However, my cells are not together (ie not a range).

Basically what I am trying to do is sum up these cells (=CS3+CN3+CG3+BW3+BO3+BH3+BE3+AX3+AS3+AN3) when they actually have numbers. A straight addition formula (like above) just returns a "#VALUE!" error. I'm sure I'm missing something simple, but I can't for the life of me figure out what.

This seems to be happening throughout my spreadsheet when I try to add up cells like these. An example of the forumla I am using in one of the cells I am trying to add up is: =IF(CE3="","",VLOOKUP(CE3,'Reference Matrix'!$A$143:$B$145,2,FALSE))

Any suggestions?

Thanks!

J

 

[JoeMo]

Try:
=SUM(CS3,CN3,CG3,BW3,BO3,BH3,BE3,AX3,AS3,AN3)

 

[Aladin Akyurek]

Does...

=SUM(CS3,CN3,CG3,BW3,BO3,BH3,BE3,AX3,AS3,AN3)

do what you want?

 

[Japster]

Wow... Rookie mistake. I would have sworn I had tried that, but that worked great!


Thank you both for your quick responses!

J