I am very conversant with pivot analysis but I do not want to use it for this for my table.
I want to be able to make calculations between a date range. For instance, sales of a particular product from 1st of April to 22nd of June.
It would defeat the purpose of an open question and answer forum to email an answer to you...
You need to set up an area of your sheet to construct your query parameters and then use DSUM to sum your data based on those. see: http://office.microsoft.com/en-us/excel-help/dsum-function-HP010342460.aspx
OR use SUMIFS function with a series of conditions which must all be logically AND (which should suit you to do product="X", date>1st April, date<22nd June etc)
You can use
If you don't want to take the product name into consideration, just remove its corresponding parameter, like so:
Suppose I have the ff. table:
To get the sum of the prices for Product C starting from 6/20/2012 to 7/3/2012, use the following formula:
You could also use helper cells to contain the "criteria" for your sum, like the ff:
The yellow cell above contains the formula: