Countif help

[confusedjo]

I am currently trying to count (how many feilds have numbers in them or not blank) in K6:K152 (total Round 1) if there corresponding columns E6:E152 (player Grade) contain a certain grade eg: A

I am trying to find out how many players from grade A (E6:E152) played in round 1 (K6:152 - which contains there total score) I will then be using the same forumula to found how many players played in round 2,3

example of what im needing :-
count(k6:k152) if (E6:E152,"A")

Table setup:
Player #, Player, Name, Grade, Score, Score, Total Score (round 1)

 

[T. Valko]

I am currently trying to count (how many feilds have numbers in them or not blank) in K6:K152 (total Round 1) if there corresponding columns E6:E152 (player Grade) contain a certain grade eg: A

I am trying to find out how many players from grade A (E6:E152) played in round 1 (K6:152 - which contains there total score) I will then be using the same forumula to found how many players played in round 2,3

example of what im needing :-
count(k6:k152) if (E6:E152,"A")

Table setup:
Player #, Player, Name, Grade, Score, Score, Total Score (round 1)

Maybe something like this...

=SUMPRODUCT(--(E6:E152="A"),--(ISNUMBER(K6:K152)))

 

[Aladin Akyurek]

Try...

=SUMPRODUCT(--ISNUMBER(K6:K152),--(E6:E152="A")

On Excel 2007 or later

=COUNTIFS(K6:K152,">=0",E6:E152,"A")

 

[T. Valko]

Try...

=SUMPRODUCT(--ISNUMBER(K6:K152),--(E6:E152="A")

Looks like you're missing a closing parenthesis.

=SUMPRODUCT(--ISNUMBER(K6:K152),--(E6:E152="A"))

 

[confusedjo]

Thank you!!
=COUNTIFS(K6:K152,">=0",E6:E152,"A") - works perfectly
=SUMPRODUCT(--ISNUMBER(K6:K152),--(E6:E152="A")) - doesnt appear to like me much and is returning a 0 value when i tested this (this may be because the K column have a sum forumula and therefore showing 0 (i altered the countifs forumla to >=1 to resolve this))
Thank you for your time.

 

[T. Valko]

Thank you!!
=COUNTIFS(K6:K152,">=0",E6:E152,"A") - works perfectly
=SUMPRODUCT(--ISNUMBER(K6:K152),--(E6:E152="A")) - doesnt appear to like me much and is returning a 0 value when i tested this (this may be because the K column have a sum forumula and therefore showing 0 (i altered the countifs forumla to >=1 to resolve this))
Thank you for your time.

If you're using Excel 2007 or later then the COUNTIFS function is the best choice.

If you want to change the condition to be >=1 then:

=SUMPRODUCT(--(K6:K152>=1),--(E6:E152="A"))

Assumes no text entries in K6:K152.

 

[Aladin Akyurek]

Thank you!!
=COUNTIFS(K6:K152,">=0",E6:E152,"A") - works perfectly
=SUMPRODUCT(--ISNUMBER(K6:K152),--(E6:E152="A")) - doesnt appear to like me much and is returning a 0 value when i tested this (this may be because the K column have a sum forumula and therefore showing 0 (i altered the countifs forumla to >=1 to resolve this))
Thank you for your time.

That's great. Thanks for providing feedback. The SumProduct formula can be modified in a similar manner if needed.

 

[confusedjo]

ty

 

[T. Valko]

ty

yw