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

Natalia Pagano

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

Which column is [Contract Information]@row?

Natalia Pagano

@Paul Newcome That would be the department name i.e Agency Operations, Carrier Operations, etc.

Paul Newcome

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.

Natalia Pagano

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

Paul Newcome

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

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