#### Doosht

Associate
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.

#### james.miller

Soldato
Change the cell format to hide zeros or change the formula to check the contents of the cells you are summing first ie =if(a1="","",sum(a1:d1))

#### Doosht

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

#### Doosht

Associate
OP
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)

#### BigT

Soldato
=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)

#### Doosht

Associate
OP
=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!

#### james.miller

Soldato
=IF(SUM(D8-B8)=0,"",SUM(D8-B8))

This ignores zeros, better to use =if(d8="","",d8-b8)