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


--
(When sending e-mail, use address (E-Mail Removed))
Arvi Laanemets


"Dynamo" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>