Hi Sean

=SUMPRODUCT((Locations=$A$1)*(ProductCode=$B$1)*
(TEXT(DATE(SalesDate,"yymmdd")=text($C$1,"yymmdd") )*Salesunits)

If it were everything for the Month of the date entered in C2 that you
required change to
=SUMPRODUCT((Locations=$A$1)*(ProductCode=$B$1)*
(NONTH(SalesDate,"yymmdd")=MONTH($C$1))*Salesunits )

--
Regards

Roger Govier


"Sean" wrote in message
oups.com...
I have a Database listing that shows Sales of Products by location by
Date. I want to extract from this a total for each item by location by
Date

My parameters are in the following cells

A1 = Location number
B1 = Product Code
C2 = Sales Date

My database has all 3 above detailed in 3 columns + a total Sales
Units column (I have all 4 named ranged, Locations, ProductCode,
SalesDate,SalesUnits)

I wish to return a value of total sales in A5, based on the detail I
have entered in A1, B1 and C1. How would I do this?

Thanks