Countif Formula not reporting Accurate number

Laura_SolAlt_5804

Hello,

I'm trying to report a metric on a dashboard and am using the following formula:

=COUNTIF({Master Project Tracking Range 1}, ISBLANK(@cell) and the total is 29, however when I filter the grid the data is pulled from there are only 19 blank cells.

I've also tried =COUNTIF({Master Project Tracking Range 1}, "") and get 29. 🤔

Paul Newcome

Because it is counting the 10 blank rows at the bottom of the sheet. Either subtracting 10 form the COUNTIF or switching to a COUNTIFS and including a range/criteria set for a column that is not blank should solve the problem.

Paul Newcome

Because it is counting the 10 blank rows at the bottom of the sheet. Either subtracting 10 form the COUNTIF or switching to a COUNTIFS and including a range/criteria set for a column that is not blank should solve the problem.

Laura_SolAlt_5804

Got it! Thank you!

Paul Newcome

Happy to help. 👍️