SOLVED
Home

Countif/Sumif - 2 Criteria

%3CLINGO-SUB%20id%3D%22lingo-sub-506378%22%20slang%3D%22en-US%22%3ECountif%2FSumif%20-%202%20Criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-506378%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20have%20a%20dataset%20and%20worked%20out%20couple%20of%20formulas%20of%20what%20I%20need%20and%20stumbled%20on%20my%20last%20formula%20where%20I%20am%20trying%20to%20do%20a%20count%20after%20double%20match.%20Please%20see%20attached%20sample%20file%20and%20the%20info%20in%20text%20box%20clearly%20outlines%20what%20I%20am%20trying%20to%20accomplish.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3CP%3EJay.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-506378%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-506754%22%20slang%3D%22en-US%22%3ERe%3A%20Countif%2FSumif%20-%202%20Criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-506754%22%20slang%3D%22en-US%22%3E%3CP%3ETry%20modifying%20your%20formula%20to%20this%3A%3CBR%20%2F%3E%3DCOUNTIFS(%24C%3A%24C%2CG%242%2C%3CBR%20%2F%3E%24D%3A%24D%2C%24E3)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-506766%22%20slang%3D%22en-US%22%3ERe%3A%20Countif%2FSumif%20-%202%20Criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-506766%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20did%20try%20the%20modified%20formula%20but%20the%20answer%20is%20still%20incorrect.%20The%20result%20is%200.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-506775%22%20slang%3D%22en-US%22%3ERe%3A%20Countif%2FSumif%20-%202%20Criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-506775%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%20rel%3D%22noopener%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20all%20good%20now%2C%20when%20I%20copied%20and%20pasted%20one%20of%20the%20cell%20references%20got%20changed%20to%20the%20wrong%20cell.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%20Works%20great.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-506788%22%20slang%3D%22en-US%22%3ERe%3A%20Countif%2FSumif%20-%202%20Criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-506788%22%20slang%3D%22en-US%22%3EYou%E2%80%99re%20welcome.%3C%2FLINGO-BODY%3E
AVP68
Occasional Contributor

Hello,

I have a dataset and worked out couple of formulas of what I need and stumbled on my last formula where I am trying to do a count after double match. Please see attached sample file and the info in text box clearly outlines what I am trying to accomplish.

 

Thanks.

Jay.

4 Replies
Solution

Try modifying your formula to this:
=COUNTIFS($C:$C,G$2,
$D:$D,$E3)

@Twifoo 

I did try the modified formula but the answer is still incorrect. The result is 0.

 

 

@Twifoo 

It's all good now, when I copied and pasted one of the cell references got changed to the wrong cell.

 

Thanks! Works great.

 

 

You’re welcome.
Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies