Home

Excel function Sumifs

%3CLINGO-SUB%20id%3D%22lingo-sub-456900%22%20slang%3D%22en-US%22%3EExcel%20function%20Sumifs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-456900%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20you%20tell%20me%20why%20the%20formula%20in%20color%20ORANGE%20gives%20me%20the%20result%20of%200.%26nbsp%3B%20Should%20be%2013%3C%2FP%3E%3CP%3EI%20think%20SumIfs%20function%20should%20give%20me%20the%20answer%20-%20let%20me%20know%20how%20to%20correct.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20Attached.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3ERay%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-456900%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-456969%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20function%20Sumifs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-456969%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F220885%22%20target%3D%22_blank%22%3E%40Raymond%20Sanner%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHi%20Ray%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWith%20OR%20condition%20it%20shall%20be%20used%20as%20explained%20here%26nbsp%3B%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3E%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%2Fformula%2Fsumifs-with-multiple-criteria-and-or-logic%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexceljet.net%2Fformula%2Fsumifs-with-multiple-criteria-and-or-logic%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Raymond Sanner
New Contributor

Can you tell me why the formula in color ORANGE gives me the result of 0.  Should be 13

I think SumIfs function should give me the answer - let me know how to correct.

 

See Attached.

 

Thanks,

Ray

1 Reply

@Raymond Sanner 

Hi Ray,

 

With OR condition it shall be used as explained here https://exceljet.net/formula/sumifs-with-multiple-criteria-and-or-logic

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