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, Descript...
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