Why is this formula not pulling correct information

tmagana · 12/12/23

This formula is reflecting 18 but when going on the sheet that is referencing and filtering to show only blanks in that column only 8 are appearing.

KPH · 12/12/23

Is the formula counting 10 blank rows at the bottom of the sheet, but the filter excluding those?

tmagana · 12/20/23

Yes, How do I fix this

Paul Newcome · 12/21/23

Subtract 10 from the output.

=COUNTIFS(..........) - 10

tmagana · 01/10/24

But how do I fix the formula ?

Paul Newcome · 01/10/24

@tmagana You fix it by subtracting 10 from it.

Answers