• 460K Members
• 10K Online
• 557K Conversations
SOLVED

## Countif/Sumif - 2 Criteria

Occasional Contributor

# Countif/Sumif - 2 Criteria

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

# Re: Countif/Sumif - 2 Criteria

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

# Re: Countif/Sumif - 2 Criteria

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

# Re: Countif/Sumif - 2 Criteria

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

Thanks! Works great.

Highlighted

# Re: Countif/Sumif - 2 Criteria

You’re welcome.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies