On my test sheet I have a Customer name (TEST!A12) and a Product ID
(TEST!C12).

I want to find out how much of the product that customer pulled per
month from my data sheet. (TICKETS!)

Below is the formula I used, to try and pull the information for the
month of Jan. But it returns #VALUE

=SUMPRODUCT(--(TICKETS!C2:C10000=1/1/5),--(TICKETS!C2:C10000<2/1/5),-
-(TICKETS!E2:E10000=TEST!A12),--(TICKETS!G2:G10000=TEST!C12),TICKETS!K2:K10000)

Thanks for any help you can give me.


By the way, if I haven't said it.. Thanks.everyone has been great in
putting up with all my questions and requests for help :)

Wally