Sum up individual cells (not a range)

Japster

New Member
Joined
Sep 15, 2014
Messages
2
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
 

Japster

New Member
Joined
Sep 15, 2014
Messages
2
Wow... Rookie mistake. I would have sworn I had tried that, but that worked great!


Thank you both for your quick responses!

J
 

Forum statistics

Threads
1,086,123
Messages
5,387,978
Members
402,092
Latest member
S_S

Some videos you may like

This Week's Hot Topics

Top