Ask for help for multiple criteria

Emily

Active Member
Dear All,

For the following data, how can I obtain the frequency if row 1 is C and row 2 is 1990.

A B C C C B C A C
1992 1990 1990 1923 1990 2050 1901 1990 1991

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
=SUMPRODUCT((A1:I1="C")*(A2:I2=1990))

Thanks.
I never thought using "SUMPRODUCT". Is it possible to use COUNTIF instead?

Aladin's formula is elegant and efficient. Just to add some alternates that are not so efficient in this case ...

{=SUM(IF((A1:I1="c")*(A2:I2=1990),1,0))}

or

{=SUM(IF(A1:I1="C",IF(A2:I2=1990,1,0),0))}

Regards!

Yogi

Thanks a lot

Replies
19
Views
923
Replies
3
Views
115
Replies
1
Views
165
Replies
2
Views
135
Replies
5
Views
263

1,220,011
Messages
6,151,450
Members
451,028
Latest member
greekness1

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back