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.


"Bumpa" wrote:

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