L
Link
Want to determine what percentage of all cases were
successful. Please help.
successful. Please help.
F
Frank Kabel
Hi
you may provide some more detail. e.g. about your data structure!
you may provide some more detail. e.g. about your data structure!
L
Link
Fairly simple.
Column D has s/u/na for successful, unsuccessful, not
applicable.
Want to determine what percentage of cases were successful.
Column D has s/u/na for successful, unsuccessful, not
applicable.
Want to determine what percentage of cases were successful.
P
Peo Sjoblom
=COUNTIF(D2
200,"s")/COUNTA(D2200)
format as percentage
--
Regards,
Peo Sjoblom
(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
200,"s")/COUNTA(D2200)format as percentage
--
Regards,
Peo Sjoblom
(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
J
Jay
Column D has s/u/na for successful, unsuccessful, not
One way:
=COUNTIF(D, "s")/COUNTA(D)
and format the resulting cell as a percentage.
One way:
=COUNTIF(D
, "s")/COUNTA(D)and format the resulting cell as a percentage.