View Single Post
  #1   Report Post  
alias abuhasan
 
Posts: n/a
Default 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