Countifs

[Russk68]

Hi All,
I thought this would work:
=COUNTIFS(AW3:BF522,D2,AV3:AV522,C3)
The D2 criteria can be found in multiple columns and C3 criteria is in just found in 1 column.

Help!

Thank you!

Russ

 

[jproffer]

Sample data with expected results (even if you have to manually enter the expected results) would help a lot? Even just a few rows...AV to BF isn't all that many columns to make up

 

[Aladin Akyurek]

That's exactly as COUNTIFS is designed to do. It will correlate AV3:AV522 with the first column of AW3:BF522.

The following might be your intent. Control+shift+enter, not just enter:

=SUM(IF(AW3:BF522=D2,IF(AV3:AV522=C3,1)))

If you are afraid of control+shift+enter...

=SOMPRODUCT((AW3:BF522=D2)*(AV3:AV522=C3))

 

[jproffer]

Somproduct = sumproduct

 

[Russk68]

Actually, It seems to me that array formulas take long to calculate and I try not to use them.
Are there pros and cons between your 2 formulas?

 

[Aladin Akyurek]

Actually, It seems to me that array formulas take long to calculate and I try not to use them.
Are there pros and cons between your 2 formulas?

Not much, because a SUMPRODUCT formula is also an array-processing formula, without control+shift+enter in this case.

 

[Russk68]

Got it!
All working good.
Thank you very much!

 

[Aladin Akyurek]

Got it!
All working good.
Thank you very much!

You are welcome.