Counting number of occurrences based on 2 ranges

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
 
A

Arvi Laanemets

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count in a range of numbers 9
Count Based On Multiple Criteria 2
count occurances of values in column if condition is met 0
Counting Cells With Multiple Criteria on Multiple Sheets 0
Counting Occurrance of # In Range 2
Counting Cells With Multiple Criteria on Multiple Sheets 0
How to count the number of occurrence within string? 2
Count of Font Format 1

Top