Add up Q
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
|