Chart Plotting "0" IF Formula works for 1 Column but not the rest!

Question

Hello,

I tried this formula on another sheet and it worked but now replicating for another sheet but doesn't work.

In the first sheet, I wrote out the below formula and it worked; I was able to "hide" the "0" so it wouldn't plot in a chart. As you can see below it worked.

Tried a similar formula for another sheet. It worked for the first row but when I dragged down the formal the rest calculated to "22"

Not sure, what I'm missing here.

Help appreciated!

Paul Newcome · Answer

=IF(COUNTIFS(...............) > 0, COUNTIFS(..................))

And you are going to want the COUNTIFS to be the same.

Natalia Pagano · Answer

@Paul Newcome Would you be able to provide a sample formula string?

Paul Newcome · Answer

It looks like (in the second screenshot) you have two different COUNTIFS going inside of the IF statement. The COUNTIFS should be repeated as the output.