If a cell is blank make it blank not 0

[ACrossley1]

Hi

I have created a sumif formula - =SUMIF('G1'!$AL$4:$AL$23,$A2,'G1'!$AM$4:$AM$23)

However, when there is no data i wanted to make it blank rather than 0 - using this formula =IF(SUMIF('G1'!$AL$4:$AL$23,$A2,'G1'!$AM$4:$AM$23)=0,"",SUMIF('G1'!$AL$4:$AL$23,$A2,'G1'!$AM$4:$AM$23))

However, sometimes there is a cell that should = 0 but it puts it blank instead

How do i create a if formula like above that will:
-make a cell blank if there is no data
-make a cell keep the 0, if the data is 0

Thanks.
Adam.

[Fluff13]

How about
=if(countif('G1'!$AL$4:$AL$23,$A2)=0,"",SUMIF('G1'!$AL$4:$AL$23,$A2,'G1'!$AM$4:$AM$23))

[ACrossley1]

Hi.

I couldnt get that to work unfortunately. I have attached the document to see if that helps anyone?

As you can see - it shows sd and se as blank when in fact it should be 0.

Thanks.
Adam.

[Fluff13]

Ok, how about
=IF(COUNTIFS('G1'!$AL$4:$AL$23,$A2,'G1'!$AU$4:$AU$23,"<>")=0,"",SUMIF('G1'!$AL$4:$AL$23,$A2,'G1'!$AU$4:$AU$23))

[SirDreadwolf]

Why not just use conditional formatting to make it simpler i.e. if the value in the cell is equal to 0 then color the font white?

[ACrossley1]

Hi!

I think that has worked! Thank you very much!

[Fluff13]

You're welcome & thanks for the feedback.