Counting number of occurrences based on 2 ranges

  • Thread starter Thread starter Dynamo
  • Start date Start date
D

Dynamo

Hi

Have two ranges a1:a55 and e1:e55 and want to count the number of occurrences
where cell a = "Yes" and cell e = 27-11-03. Cant use countif because only counts
the occurrences based on one range.

Any help appreciated
Regards
Dynamo
 
Hi

=SUMPRODUCT((a1:a55="Yes")*(e1:e55=DATE(2003,11,27)))
or
=SUMPRODUCT((a1:a55="Yes")*(e1:e55=MyDate))
where MyDate is reference to cell with date
 
Back
Top