# Sum up individual cells (not a range)

#### Japster

##### New Member
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

### Excel Facts

Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
Try:
=SUM(CS3,CN3,CG3,BW3,BO3,BH3,BE3,AX3,AS3,AN3)

Does...

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

do what you want?

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

Thank you both for your quick responses!

J

Replies
3
Views
119
Replies
7
Views
177
Replies
4
Views
223
Replies
10
Views
614
Replies
9
Views
240

1,219,799
Messages
6,150,320
Members
450,951
Latest member
kh198

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back