COUNT or COUNTIF with AND

[BHammy]

I'm getting stumped here, trying to make a formula. Trying to count the number of instances in which column A has a "1" and column F has an "E." And then being able to count the instances in which column A has "2" and column F has "G", etc.

What I have so far is

=COUNT(IF(A:A="1",IF(F:F,"E",0)))

I know that's not it -- that's what I have so far. Can you help me with creating this formula?

Thanks!

[Jonmo1]

Try

=COUNTIFS(A:A,1,F:F,"E")

[daddylonglegs]

You need COUNTIFS function (with an "S" on the end) for multi-conditional counting, i.e.

=COUNTIFS(A:A,1,F:F,"E")

[BHammy]

This is awesome. Thank you!

[Jonmo1]

Great, thanks for the feedback