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.
<colgroup><col></colgroup><tbody>
</tbody>
Thank-you in advance for any help!
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.
International |
International Reissue |
International Schedule Change |
Domestic |
Domestic Reissue |
Trans Tasman |
Trans Tasman Reissue |
Domestic Schedule Change |
Trans Tasman Schedule Change |
<colgroup><col></colgroup><tbody>
</tbody>
Thank-you in advance for any help!