how to use sumproduct

[Guest]

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