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