Countif Formula not reporting Accurate number
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. 🤔
Best Answer
-
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.
Answers
-
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.
-
Got it! Thank you!
-
Help Article Resources
Categories
Check out the Formula Handbook template!