Dear All
Here I have attached File containing 2 sheets
One is for Report and another is for Data Entry.
In Report Sheet Date range given in column H (H5 and H6)
I want to make sum for B12 to B15 Item for date Range specified between H5 and H6
Data is in Food Purchase sheet
Suppose I want to make sum for Fruits for Date Range 01/08/2014 to 15/08/2014
then output should come 32000/-
it should not count fruit Fruit value of 16/08/2014 - 3000/- becuse it is out of date range
Please help
Atul
Bookmarks