Counting with multiple criteria

[Psychologic]

This may be a case of not knowing the best search terms to use, but I really have tried for way longer than I'd like to admit.

1	1	1	2	2	2	3	3	3
A	X	F	T	Ft	U	Ax	F	V

<tbody>
</tbody>

I'm trying to count the number of columns where:
-Row 1 = a specific number
-Row 2 = one of many codes in a list of arbitrary length elsewhere on the spreadsheet
-The codes are matched as whole whole cells (ie- "Ft" isn't a match for "F" and vice versa)


The codes alone are easy enough to count with SUMPRODUCT(COUNTIF(range,codeArray)), but I'm not sure how to successfully restrict the counting to columns where, for example, Row 1 = 2.

I feel I'm missing something obvious, but I'm a bit frustrated at this point. Thank you for any insight you can provide.

 

[Psychologic]

So the pattern holds true... spend hours looking for something, finally ask about it, then find the obvious answer 5 minutes later.

 

[Marcelo Branco]

Try COUNTIFS

For example 1 and F
=COUNTIFS(A1:I1,1,A2:I2,"F")

Hope this hepls

M.

 

[Aladin Akyurek]

So the pattern holds true... spend hours looking for something, finally ask about it, then find the obvious answer 5 minutes later.

And that answer is?

 

[Psychologic]

And that answer is?

=SUMPRODUCT(COUNTIFS(row2,codeArray,row1,number))

I swear I tried that exact solution before and it failed. No idea what I mistyped the first time.

 

[Aladin Akyurek]

=SUMPRODUCT(COUNTIFS(row2,codeArray,row1,number))

I swear I tried that exact solution before and it failed. No idea what I mistyped the first time.

Right...