Adding Values with Formulas Attached

[sully2]

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?

 

[mohitspamz]

=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]

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]

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