Average

[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

 

[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

 

[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




.

 

[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?

 

[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"))