I have the following sheet that lists expenses by date and allows you to sort each payment into an expense category (pulled from a sheet).
I have an expenses sheet where I'd like to tally up all the values to the left of an expense category, then add those numbers up and insert the value into the appropriate cell in my 'expenses' sheet.
I know the steps I need to take are:
- Get expense category for the column the cell resides in in the 'expenses' sheet.
- Search for that category string within F4:F14 of my payments sheet.
- Find all corresponding payments in rows where the expense category matches.
- Tally them up.
- Display them in the 'expenses' sheet in B2.
So far I have this but it's not working in any way so far, I'm not sure how to do a recursive function to pull a dynamic number of values together to tally them.
=VLOOKUP($B1,payments!$F3:F14,4,FALSE)
I'm looking to get 861
as the value for B2 in the expenses sheet.
861
, or it should, rather. I posted a solution that works.