Home

Combined Sumif & Sumifs

%3CLINGO-SUB%20id%3D%22lingo-sub-846847%22%20slang%3D%22en-US%22%3ECombined%20Sumif%20%26amp%3B%20Sumifs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-846847%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20combine%20two%20Sumif%20%26amp%3B%20Sumifs%20formulas%20or%20find%20a%20soulution%20with%20my%20issue.%26nbsp%3B%20Is%20there%20another%20way%20to%20solve%20my%20%3CSPAN%3Edilemma.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F130962iDAFF30139FB19A92%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_1.png%22%20title%3D%22clipboard_image_1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-846847%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-847448%22%20slang%3D%22en-US%22%3ERe%3A%20Combined%20Sumif%20%26amp%3B%20Sumifs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-847448%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F406619%22%20target%3D%22_blank%22%3E%40mcavas%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDo%20you%20mean%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DSUMIFS(B23%3AB28%2CA23%3AA28%2C%22%26lt%3B%26gt%3Bskip%22%2CC23%3AC28%2C%22pay%22%2CB23%3AB28%2C%22%26lt%3B%26gt%3B0%22)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-847499%22%20slang%3D%22en-US%22%3ERe%3A%20Combined%20Sumif%20%26amp%3B%20Sumifs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-847499%22%20slang%3D%22en-US%22%3EThank%20you%20for%20the%20reply%20back.%20However%2C%20the%20formula%20did%20not%20address%20the%20Pending%20column.%20Within%20the%20Combined%20formula%20table%2C%20when%20I%20placed%20skp%20in%20the%20Pending%20column%2C%20the%20formula%20accounted%20only%20the%20Resolute%20column.%20In%20other%20words%2C%20if%20skp%20is%20placed%20in%20the%20Pending%20column%20and%20n%2Fa%20is%20placed%20in%20the%20Resolute%20column%2C%20I%20should%20end%20up%20with%20a%20total%20amount%20of%204.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-847520%22%20slang%3D%22en-US%22%3ERe%3A%20Combined%20Sumif%20%26amp%3B%20Sumifs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-847520%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F406619%22%20target%3D%22_blank%22%3E%40mcavas%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFormula%20returns%204%2C%20please%20check%20attached.%20I'm%20not%20sure%20what%20%22n%2Fa%22%20means%20for%20Resolute%20column%2C%20it%20calculates%20for%20Pending%20%26lt%3B%26gt%3B%20skp%20and%20Resolute%3Dpay%3C%2FP%3E%3C%2FLINGO-BODY%3E
mcavas
New Contributor

I need to combine two Sumif & Sumifs formulas or find a soulution with my issue.  Is there another way to solve my dilemma.

clipboard_image_1.png

3 Replies
Highlighted

@mcavas 

Do you mean

=SUMIFS(B23:B28,A23:A28,"<>skip",C23:C28,"pay",B23:B28,"<>0")

?

Thank you for the reply back. However, the formula did not address the Pending column. Within the Combined formula table, when I placed skp in the Pending column, the formula accounted only the Resolute column. In other words, if skp is placed in the Pending column and n/a is placed in the Resolute column, I should end up with a total amount of 4.

@mcavas 

Formula returns 4, please check attached. I'm not sure what "n/a" means for Resolute column, it calculates for Pending <> skp and Resolute=pay

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
14 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies