Hey Forum,
Here is an interesting challenge I am looking to create:
I am trying to create a tracking document. Basically what I want it to show me is:
Based on the date in column a, return for me the sum in column b for the referenced sheet.
So far, I am using indirect to reference the sheet I want, but I don't know how to sum up everything for that date. I am thinking SUMIF??...
Any advice?
Attached is a mock up of the spreadsheet.
Thanks for the help!
Aaron
orders.xlsxorders.xlsx
Bookmarks