COUNTIFS Across multple columns and multiple items per column

[tarz_213]

Hello!

I am having some trouble that I am hoping to get some assistance.

=COUNTIFS(H11:H1000,Q4,I11:I1000,W3)

I need to calculate that if UK(Q4) appears in column H and then also count if 9 different options appear in column I. Currently my formula is only for 1 of these options (W3) as I cannot get a formula to work for more than 1 option in column I. These can be represented as text if cells do not work.

[TABLE="width: 226"]
<colgroup><col></colgroup><tbody>[TR]
[TD]International[/TD]
[/TR]
[TR]
[TD]International Reissue[/TD]
[/TR]
[TR]
[TD]International Schedule Change[/TD]
[/TR]
[TR]
[TD]Domestic[/TD]
[/TR]
[TR]
[TD]Domestic Reissue[/TD]
[/TR]
[TR]
[TD]Trans Tasman[/TD]
[/TR]
[TR]
[TD]Trans Tasman Reissue[/TD]
[/TR]
[TR]
[TD]Domestic Schedule Change[/TD]
[/TR]
[TR]
[TD]Trans Tasman Schedule Change[/TD]
[/TR]
</tbody>[/TABLE]


Thank-you in advance for any help!

 

[FormR]

Hi, welcome to the board!

If those 9 options are listed individually in cells W3:W11 for example then you could try:

=SUMPRODUCT(COUNTIFS(H11:H1000,Q4,I11:I1000,W3:W11))