Counting occurrences with 2 seperate criteria
 

I have a worksheet in which one column is a date and the other is a text
value (such as F). I need a formula which will count the instances in which
the value F occurs for a date range such as 01/01/2009-02/01/2009.
--
dant

Counting occurrences with 2 seperate criteria
 

With dates in column A and values in column B:

=SUMPRODUCT(--(A1:A30DATE(2008,12,31)),--(A1:A30<DATE(2009,2,1)),--(B1:B30="F"))
--
Gary''s Student - gsnu200843


"Dant" wrote:

I have a worksheet in which one column is a date and the other is a text
value (such as F). I need a formula which will count the instances in which
the value F occurs for a date range such as 01/01/2009-02/01/2009.
--
dant