Forum Discussion
Can Excel do this? And if so, how?
I have a workbook with 6 or 7 sheets broken down by expense type for an RV i.e. Fuel, Lodging, Equipment, Maintenance, etc.
On each sheet I have several columns... Date, Location, Cost, Description, etc
The final sheet is a Totals Page which is broken down by month/year.
Can Excel go to each of the preceding pages, search the Date column to find all dates within a certain month, and total up all the expenses from that month across all categories into a single cell on the last page?
If so, How?
Attached is the workbook in question..
4 Replies
This workbook would be taylor-made for an INDIRECT (w/ no helper columns) if you label your "cost" columns the same across all sheets.
booberboo [Click here](javascript:alert(1))
Please see attached. Added helper columns in each sheet to get a reference to the month for each date (i.e. Nov 6, 2019 becomes 112019). The Total page uses SUMIF to sum amounts from the relevant column in each sheet using the month reference as the criteria. On the Insurance & Subscription page you need to determine which cost you which to track. Not sure if you are looking for cash flow (the yearly cost) or the monthly expense. I added some data (in yellow) assuming you want the latter. Up to you!
Thanks alot. I knew it had to be simple. Other people were telling me to use LOOKUP and VLOOKUP functions which just didnt seem to make sense when I researched them online
