I'm making a workbook in Excel 2003 that tracks store sales & profit (see pic below). I have daily reports where the employee enters all the data & then I have a "Monthly" tab that consolidates all the daily data into a monthly report.
The monthly report uses this SUMIF formula to tabulate each category (Daily Sales, Daily Units, Daily Profit) for each line item:
=SUMIF('Daily - Jan'!$7:$7,'Daily - Jan'!$F$7,'Daily - Jan'!23:23)
This worked beautifully, until I realized that the line items will most likely change periodically mid-month, which will in turn mess-up my monthly SUMIF formulas because it expects the data to be all on one row.
I've racked my brain trying to figure-out an alternative method to tabulate data on different rows and per each category, but have not been successful.
Any thoughts?
Many thanks.
SUMIF Formula.jpg
Bookmarks