Is error help using counta

[twinpowr]

Hi i am having problems intergrating iserror with this formula

=IF(COUNTA(H25:K25)="","n/a",COUNTIF(H25:K25,"a")/COUNTA(H25:K25))

i can get it to work with other formulas eg average etc but can't seem to get this to work

any help would be aprrecieated.

Alistair.

 

[Andrew Poulsom]

COUNTA returns a number not null. Maybe you need:

=IF(COUNTA(H25:K25)=0,"n/a",COUNTIF(H25:K25,"a")/COUNTA(H25:K25))

 

[Jonmo1]

Counta returns a number (the count of non empty cells).
So counta will never = ""..

Try

=IF(COUNTA(H25:K25)=0,"n/a",COUNTIF(H25:K25,"a")/COUNTA(H25:K25))

 

[twinpowr]

Hi Guys

thanks for the help, of course easy when you know how put me on the right track here is what i used

=IF(COUNTA(H25:K25)=0,"",COUNTIF(H25:K25,"a")/COUNTA(H25:K25))

I added the 0 as you suggested then simply removed the n/a and replaced with "" and that gave me the blank i was looking for.

Thanks again, you guys are the best.

Alistair