Adding cost based on lookup?

[adamc26]

I’m trying to sum Costs in the cash out column based on the room the item is going in. For example, I want D15 (Actual Cash Out for Living Room) to show $1700. I’ve tried different Vlookups and sumif functions and I can’t get anything to work

[#2]

@adamc26 I think you want SUMIF()

=SUMIF(Sheet2!B:B, A7, Sheet2!C:C)

This assumes the actual total tables is on Sheet2 and the room name is in col 2 and the $$ in col C.  Paste this starting in row 4 of the Actual Cash Out column.