Adding cost based on lookup?

%3CLINGO-SUB%20id%3D%22lingo-sub-1548789%22%20slang%3D%22en-US%22%3EAdding%20cost%20based%20on%20lookup%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1548789%22%20slang%3D%22en-US%22%3EI%E2%80%99m%20trying%20to%20sum%20Costs%20in%20the%20cash%20out%20column%20based%20on%20the%20room%20the%20item%20is%20going%20in.%20For%20example%2C%20I%20want%20D15%20(Actual%20Cash%20Out%20for%20Living%20Room)%20to%20show%20%241700.%20I%E2%80%99ve%20tried%20different%20Vlookups%20and%20sumif%20functions%20and%20I%20can%E2%80%99t%20get%20anything%20to%20work%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1548789%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor
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
1 Reply
Highlighted

@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.