I am trying to create a Countif formula where:
-Count the number of cells where F = Yes
-AND the date in I is > than the date in H
I have tried it several ways and thought I had it, but I am having trouble now.
Sorry if this is a novice question.
I am trying to create a Countif formula where:
-Count the number of cells where F = Yes
-AND the date in I is > than the date in H
I have tried it several ways and thought I had it, but I am having trouble now.
Sorry if this is a novice question.
Try SUMPRODUCT, something like this
=SUMPRODUCT((F2:F100="Yes")*(I2:I100>H2:H100))
adjust ranges as required
Audere est facere
Did you use that exact formula? It wouldn't normally return FALSE, I'd expect a number (possibly zero)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks