Home

summing multiple columns with SUMIF

%3CLINGO-SUB%20id%3D%22lingo-sub-807068%22%20slang%3D%22en-US%22%3Esumming%20multiple%20columns%20with%20SUMIF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-807068%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20sum%20multiple%20columns%20based%20on%20the%20criteria%20in%20a%20column.%20Here%20is%20the%20formula%20I%20am%20using%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Esumif('2019%20Budget'!%24D%2414%3A%24D%24109%2C%22esop%22%2C'2019%20Budget'!G14%3AI109)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJanuary's%20budget%20numbers%20are%20in%20column%20G%20and%20February's%20budget%20numbers%20are%20in%20column%20I%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20my%20mind%20this%20formula%20should%20work%20but%20it%20is%20only%20summing%20column%20G.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20greatly%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-807068%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-807082%22%20slang%3D%22en-US%22%3ERe%3A%20summing%20multiple%20columns%20with%20SUMIF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-807082%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F393031%22%20target%3D%22_blank%22%3E%40senelson227%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI'd%20suggest%20to%20use%20SUMPRODUCT%20in%20such%20case%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DSUMPRODUCT(('2019%20Budget'!%24D%2414%3A%24D%24109%3D%22esop%22)*'2019%20Budget'!G14%3AI109)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
senelson227
Occasional Visitor

I want to sum multiple columns based on the criteria in a column. Here is the formula I am using:

 

sumif('2019 Budget'!$D$14:$D$109,"esop",'2019 Budget'!G14:I109)

 

January's budget numbers are in column G and February's budget numbers are in column I

 

In my mind this formula should work but it is only summing column G.

 

Any help would be greatly appreciated.

1 Reply

@senelson227 

I'd suggest to use SUMPRODUCT in such case

=SUMPRODUCT(('2019 Budget'!$D$14:$D$109="esop")*'2019 Budget'!G14:I109)