View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Excel - calculating a percentage

use count or counta to count the total and countif to count the pass. Divide

--
Don Guillett
SalesAid Software

"BigG" wrote in message
...
Hi All,

I have a slight problem which I can not workout and I would be grateful fo
any help.

I have a spreadsheet with a column which contains either Pass or Fail.
What
I would like to do is enter a formula at the end of the column that would
count the number of passess and taking into consideration the total number
of
cells in the column convert the total number of passes into a percentage.

Any help would be apprecaited

Big G