Counting by catagory and date range

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

On sheet one of my workbook I have dates of events in
col.B and One of 7 possible categories of event in col. L

On sheet two I have a start date in F1 and a end date in H1

I need to be able to (on sht 2 cell B3) count how many
events of Category 1 happened between the start and end
dates entered. In cell B4 I need count category 2 events
in the same date range and so on for each event category.

Is there a formula that can do this for me?
 
Something like:

=SUMPRODUCT((Sheet1!$B$1:$B$100>=$F$1)*(Sheet1!$B$1:$B$100<=$H$1)*(Sheet1!$L
$1:$L$100=1))

where 1 is the category level. Just substitute the last number for the other
categoty levels.
 
Back
Top