Simple addition only when value in cell

[coughandcathmitie]

Hi , I have a simple spreadsheet that I only want to add cells if a figure is included at get a running balance going forward . I only want the total when there is something in the adjacent cell . Every time I try it completes formula for the whole spreadsheet . I have tried various IF parameters but still can manage it . It should be simple ... maybe just a busy week Friday afternoon blindness issue !!

 

[Joe4]

Welcome to the Board!

Try this:

In cell E9:

=IF(D9<>0,D9+D6,"-")

In cell E10:

=IF(D10<>0,D10+E9,"-")

and copy down.

 

[julhs]

For E9; If(D9>””,D9+D6)

For E10; If(D10>””,E9+D10)

 

[Joe4]

For E9; If(D9>””,D9+D6)

For E10; If(D10>””,E9+D10)

A few things to note:

1. Excel does not like slanted quotation marks like in your formula (”). Those will cause errors. You need to use the straight up and down ones (").
2. By not providing a FALSE argument in your IF functions, if the condition is not met, it will return the word FALSE in the cell, which I am pretty sure they do not want. Just tell it to return nothing ("") or a dash, like I showed in my reply ("-"), since that is what their image looks like.

 

[julhs]

Yes of course you right, neglected to add ANY “If False” condition.

 

[coughandcathmitie]

excellent , thanks for the help

 

[Joe4]

You are welcome!