Using excel 2003, how would I calcuate the total cost, sorting by a name and then by date range?
Sheet1 (master spreadsheet)
Column A = List of Names
Column K = Dates Sold
Column P = Total Made
Sheet2 (report)
b2 = start date (1/2/2010)
c2 = end date (12/31/2011)
Trying to get the total cost per year for certain individuals. There may be some blank cells in sheet1.
Any help is much appreciated.
Sheet1 (master spreadsheet)
Column A = List of Names
Column K = Dates Sold
Column P = Total Made
Sheet2 (report)
b2 = start date (1/2/2010)
c2 = end date (12/31/2011)
Trying to get the total cost per year for certain individuals. There may be some blank cells in sheet1.
Any help is much appreciated.
