Counting occurrences with 2 seperate criteria

  • Thread starter Thread starter Dant
  • Start date Start date
D

Dant

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.
 
With dates in column A and values in column B:

=SUMPRODUCT(--(A1:A30>DATE(2008,12,31)),--(A1:A30<DATE(2009,2,1)),--(B1:B30="F"))
 
Back
Top