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.
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... Two choices: 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/enus/excelhelp/dsumfunctionHP010342460.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:
Where: Example: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:


