Average

S

Sugar

I want to find out, on average, how many of my clients
were successful with B5:B32 containing data.

if n= s/u/na (successful, unsuccessful, not applicable)


Thanks for the help
 
J

JulieD

Hi

to count the number of successful
=COUNTIF(B5:B32,"s")
so
=COUNTIF(B5:B32,"s")/COUNTA(B5:B32)
formatted as a percent will give you the percentage of clients who were
successful

Cheers
JulieD
 
S

Sugar

Thank you Julie!!!
-----Original Message-----
Hi

to count the number of successful
=COUNTIF(B5:B32,"s")
so
=COUNTIF(B5:B32,"s")/COUNTA(B5:B32)
formatted as a percent will give you the percentage of clients who were
successful

Cheers
JulieD




.
Click to expand...
 
S

Sugar

I ran into a new issue ...

I need it to ignore the open cases - "o". Obviously if I
have 32 open cases and only 5 have been closed, I don't
want it to add "o" to the average b/c that means only like
1% was successful, which isn't accurate.

Any ideas about that?
 
D

Dave Peterson

One way is to just divide by the count of the codes you want:
=COUNTIF(B5:B32,"s")/SUMPRODUCT(COUNTIF(B5:B32,{"u","s","na"}))

or count all and subtract the ones you don't want:
=COUNTIF(B5:B32,"s")/(COUNTA(B5:B32)-COUNTIF(B5:B32,"o"))
 
Top