• 548K Members
• 6,395 Online
• 654K Conversations
SOLVED

## Countif/Sumif - 2 Criteria

Highlighted
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)

Highlighted

# Re: Countif/Sumif - 2 Criteria

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

Highlighted

# 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
SumIf multiple columns
Gemma Telfer in Excel on
3 Replies
Multiple Selections Drop Down List (used a VBA code) & CountIfs
Teeah in Excel on
0 Replies
COUNTIF not working
sme527 in Excel on
10 Replies
Drop Down & Sumif?
Lplayer92 in Excel on
3 Replies
Totaling using two sets of data
dazedandconfused in Excel on
2 Replies
COUNTIF help
brentonhobden in Excel on
3 Replies