array - how do I do this?????

  • Thread starter Thread starter Bumpa
  • Start date Start date
B

Bumpa

column A Column B
3/1/10 sallie
3/2/10 betty
3/3/10 mary
3/4/10 sallie
3/5/10 sallie
3/6/10 betty
3/7/10 sallie

count how many times sallie appears if date is less that 3/5/10
I understand the array stuff please give me a answer
 
Hi,

Use sumproduct

=SUMPRODUCT((A1:A7<DATE(2010,3,5))*(B1:B7="sallie"))
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
Back
Top