With from to dates in C2 and D2
=SUMPRODUCT((A1:A10=C2)*(A1:A10<=D2)*(B1:B10="Pas s"))

If this post helps click Yes
---------------
Jacob Skaria


"JSS" wrote:

What is the formula to return the number of specified matching text in a
colukn but only for the rows showing after a filter is applied?

Example: How many incidences of "Pass" are there if a filter is applied to
see only dates 1/1/2009 and 3/1/2009? I tried =COUNTIF and I get the total
of all "Pass". Not the filtered data.

Date Result
1/1/2009 Pass
2/1/2009 Fail
3/1/2009 Pass
4/1/2009 Pass