# Adding Values with Formulas Attached

#### sully2

##### Board Regular
Hi and thank you in advance, I have a small table where in cell "G3" I have values eg; 45. In "H3" I have a formula -

=IF(G3=45,"50",IF(G3=60,"70",IF(G3=90,"100",IF(G3=120,"130",IF(G3="","")))))

so this formula is in "H3-H10", in "H11" I want to add all the values from "H3-H10", however after I have put in the formula in H11 -

=Sum(H3:H10) the cell remains blank, is it possible to achieve what I am trying to do (add from H3 to H10 to get a total amount in H11)? Or is it impossible to add cell values when there is a formula within that cell that produces a value?

### Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

#### mohitspamz

##### New Member
=IF(G3=45,"50",IF(G3=60,"70",IF(G3=90,"100",IF(G3=120,"130",IF(G3="","")))))

The sum isnt working because you've converted 50,70,100,130 to text by using " ", simply remove the "" and it'll convert the result to numbers instead of saving the result as text.

Hope this helps.

Regards,

Mohit

#### mfexcel

##### Well-known Member
SUM ignores text, as mentioned by Mohit.

FYI.
Excel Basic – Sum vs. “+” | wmfexcel

Hi and thank you in advance, I have a small table where in cell "G3" I have values eg; 45. In "H3" I have a formula -

=IF(G3=45,"50",IF(G3=60,"70",IF(G3=90,"100",IF(G3=120,"130",IF(G3="","")))))

so this formula is in "H3-H10", in "H11" I want to add all the values from "H3-H10", however after I have put in the formula in H11 -

=Sum(H3:H10) the cell remains blank, is it possible to achieve what I am trying to do (add from H3 to H10 to get a total amount in H11)? Or is it impossible to add cell values when there is a formula within that cell that produces a value?

#### sully2

##### Board Regular
Thanks very much for your help guys, such a simple fix.

Replies
7
Views
131
Replies
12
Views
1K
Replies
5
Views
257
Replies
6
Views
152
Replies
9
Views
183

1,129,471
Messages
5,636,514
Members
416,920
Latest member
Riskyplan

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