Troubleshooting help

[Brandy]

=COUNTIF(K6:K500,"s")/(COUNTA(K6:K500),-(--COUNTIF
(K6:K500,"O"),--COUNTIF(K6:K500,"W"),--COUNTIF
(K6:K500,"NA")

What's wrong with this? Can anyone help?

 

[Frank Kabel]

Hi
wrong syntax. What are you trying to do?

 

[Brandy]

I'm trying to determine success.

In column K there are 5 codes:
S = Successful
U = Unsuccessful
NA = N/A
W = Waiting List
O = Open

I want to determine the percentage of cases that were
successful without counting W, N/A, and O.

 

[Frank Kabel]

Hi
one way:
=COUNTIF(K1:K100,"S")/SUMPRODUCT(--(K1:K100={"S","U"}))

 

[Brandy]

You're awesome, Frank. Thanks.

-----Original Message-----
Hi
one way:
=COUNTIF(K1:K100,"S")/SUMPRODUCT(--(K1:K100={"S","U"}))

--
Regards
Frank Kabel
Frankfurt, Germany



.