Home

SumIf multiple columns

%3CLINGO-SUB%20id%3D%22lingo-sub-1008139%22%20slang%3D%22en-US%22%3ESumIf%20multiple%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1008139%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20sumif%20when%20the%20criteria%20and%20range%20are%20in%20multiple%20columns.%20Is%20this%20possible%20please%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20I%20need%20to%20know%20if%20Anytown's%20money%20has%20been%20awarded%20to%20a%20project%20in%20another%20location.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1008139%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Esumif%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1008166%22%20slang%3D%22en-US%22%3ERe%3A%20SumIf%20multiple%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1008166%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F139501%22%20target%3D%22_blank%22%3E%40Gemma%20Telfer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DSUMIFS(I%3AI%2CD%3AD%2C%22Anytown%22%2CG%3AG%2C%22Anytown%22)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1008243%22%20slang%3D%22en-US%22%3ERe%3A%20SumIf%20multiple%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1008243%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20that.%20It%20does%20seem%20to%20have%20worked%2C%20unfortunately.%20I%20think%20it%20is%20the%20sum%20range%20I%20need%20to%20work%20out.%20I%20need%20it%20to%20be%20able%20to%20add%20up%20column%20F%20and%20I%20based%20on%20D%20and%20G.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1008253%22%20slang%3D%22en-US%22%3ERe%3A%20SumIf%20multiple%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1008253%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F139501%22%20target%3D%22_blank%22%3E%40Gemma%20Telfer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Emaybe%20got%20around%20it%20although%20not%20in%20a%20sleek%20way.%3C%2FP%3E%3CP%3E%3D(SUMIF(D%3AD%2C%22Anytown%22%2CF%3AF))%2B(SUMIF(G%3AG%2C%22anytown%22%2CI%3AI))%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Gemma Telfer
Occasional Contributor

Hi 

 

I am trying to sumif when the criteria and range are in multiple columns. Is this possible please?

 

So I need to know if Anytown's money has been awarded to a project in another location. 

3 Replies
Highlighted

@Gemma Telfer 

Perhaps

=SUMIFS(I:I,D:D,"Anytown",G:G,"Anytown")

 

Highlighted

Hi @Sergei Baklan 

 

Thank you for that. It does seem to have worked, unfortunately. I think it is the sum range I need to work out. I need it to be able to add up column F and I based on D and G.

Highlighted

@Gemma Telfer 

 

maybe got around it although not in a sleek way.

=(SUMIF(D:D,"Anytown",F:F))+(SUMIF(G:G,"anytown",I:I))

Related Conversations
Taking values from certain rows based on data input
Drakerla in Excel on
5 Replies
Add Column Using Count
Tim Hunter in SQL Server on
0 Replies
reverse text to columns for .csv import
milly87 in Excel on
3 Replies