how to use sumproduct

[alias abuhasan]

I have the following of data

1/1/2003 chicken
3/4/2003 burger
4/4/2004 fish
6/7/2004 chicken

Could someone tell me:
1. Count all items on and after 3/4/2003 using sumprod. I know how to do
with countif.
2. Count all fish and chicken after 1/1/2003.

Thanks in advance.

- alias abuhasan

[Biff]

Hi!

Question 1:

Enter the date criteria in a cell:

D1 = 3/4/2003

=SUMPRODUCT(--(A1:A4>=D1),--(B1:B4<>""))

Question 2:

Enter the date and text criteria in cells:

E1 = 1/1/2003
F1 = fish
G1 = chicken

=SUMPRODUCT(--(A1:A4>=E1),--(ISNUMBER(MATCH(B1:B4,F1:G1,0))))

Biff

"alias abuhasan" <alias abuhasan@discussions.microsoft.com> wrote in message
news:8F370B36-A263-490B-9CBB-39F7C75B8001@microsoft.com...
>I have the following of data
>
> 1/1/2003 chicken
> 3/4/2003 burger
> 4/4/2004 fish
> 6/7/2004 chicken
>
> Could someone tell me:
> 1. Count all items on and after 3/4/2003 using sumprod. I know how to do
> with countif.
> 2. Count all fish and chicken after 1/1/2003.
>
> Thanks in advance.
>
> - alias abuhasan