[Solved] COUNTIF AND function issue

[Notrel]

So I'm having a bit of trouble with the COUNTIF and AND functions.

Code: Select all

=COUNTIF(AND($A$2:$A$2000="Fighting";$F$2:$F$2000="1"))

Returns Err:511

What I'm trying to do is sort through a list of game categories ("Fighting" in column A) and get a count of all of the ones which are listed as having obtained all achievements for the aforementioned category (100% in column F)

Can anyone see what I'm doing wrong here?

I've managed to get a value for COUNTIF which returns the correct value using

Code: Select all

=COUNTIF($A$1:$A$2000; "Platform")

Just not sure how to get it to work with AND.

Edit:  That did it, thanks RusselB Code: Select all =COUNTIFS($A$1:$A$2000; "Fighting"; $F$1:$F$2000; 1)

[RusselB]

Use the COUNTIFS function, While it's not in the help file for the version you are showing in your forum signature, the balloon help will assist in the organization of the parameters.

P.S: remove the quotes from the "1" at the end of your formula, otherwise you'll have other problems.