Using VLOOKUP to pull multiple values from a separate column and calculate sum

[Pat_Oreg]

Hey All,

Excel rookie here (have some classes lined up to change that but in the meantime...)

I'm making a Deposits and Expenses workbook for my grandparents' small business and they want it to function in a specific way.
While I'm sure there are different ways to accomplish this, they have their heart set on something similar to my attached workbook. Specifically the 'Expenses' sheet.

They have multiple types of expenses and would like those totals to be visible and updated as they add expenses throughout the year.

Using a key to assign text values to the type of expense incurred I'm trying to:
- Use VLOOKUP to sort my "Paid For" column for the assigned text
- Pull each associated "Amount" (value 2 columns over to each assigned text)
- Calculate the total sum of all selected "Amounts" and display it in an assigned cell

After some searching, I can find bits and pieces of the answer I'm looking for but am unable to tie it all together properly.

Thank you for any help you can provide.

[etaf]

try
=SUMIF($D$5:$D$100,F4,$B$5:$B$100)
change the rows to meet your real data

I suspect theres more to this ...

[TMS]

Another way, with Excel 365:

Please Login or Register  to view this content.

copied down.