Excel / Google Sheets 'SUM' repeating help please :)

Doosht · 13 Jun 2019 at 13:59

I've got a google sheets spreadsheet which i have multiple 'sums' on it. How can i repeat those sums down the columns without it filing in Zero's all the way down? If i don't 'drag' the formula down (and get all the zeros!) it means having to individually drag down the 'sum' on every cell i populate and there are about 12 columns worth of numbers.

Basically, i only want the sum to appear when i have filled that particular cell and not show gobbledygook or a zero beforehand.

I'm sure there must be an easy answer to this and i hope my question makes sense.

Any help appreciated. Thank you.

Doosht · 13 Jun 2019 at 17:02

Hi, thank you very much - i will try that.

Doosht · 13 Jun 2019 at 17:22

No, i've got in a pickle with that. So here is the first sum and i want to bring that down to Row 9,10, 11 etc etc and not show anything if the value is zero . =SUM(D8-B8)

Doosht · 13 Jun 2019 at 17:59

BigT said:
=IF(SUM(D8-B8)=0,"",SUM(D8-B8))

although if you really are doing SUM(D8-B8) then you don't actually need the SUM function

=D8-B8 gives the same result as =SUM(D8-B8)

Perfect, thank you!