how to use sumproduct
 

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

how to use sumproduct
 

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 wrote in message
...
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