[ms office - 2010] Countifs? HELP?

[jimbojames136]

Hi

 

Trying to use a count ifs formula.

 

=COUNTIFS(K3:K246,"A",K3:K246,"B",K3:K246,"C")

 

its to count the number of A - C grades in one column, but it keeps returning a value of 0.

 

can anybody see where i might be going wrong? or suggest an alternative to countifs ?

 

 

thanks

 

James

[pavlovs_dog]

Could you modify this.

IF Question - MrExcel Message Board

[tdawson]

It's not pretty but won't this do the job?

 

=SUM(COUNTIF(Grade,"a"),COUNTIF(Grade,"b"),COUNTIF(Grade,"c"))

 

Either that or insert a Pivot table which will count everything up for you.

[jimbojames136]

Thanks Guys, it may be messy but it works