View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
BigG BigG is offline
external usenet poster
 
Posts: 8
Default Excel - calculating a percentage

Gord,

You are a star.

Cheers

Big G

"Gord Dibben" wrote:

You changed the rules.....!!

First post reads "a column which contains either Pass or Fail"

No mention of blank cells.

Try this =COUNTIF(A3:A30,"Pass")/COUNTIF(A3:A30,"<""")

Note there are three double quotes after <


Gord

On Tue, 5 Dec 2006 11:08:01 -0800, BigG wrote:

Thank you very much Gord. Please read the reply to david's answer.

Big G

"Gord Dibben" wrote:

=COUNTIF(A3:A30,"Pass")/COUNTA(A3:A30)


Gord Dibben MS Excel MVP


On Tue, 5 Dec 2006 08:37:00 -0800, BigG wrote:

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



Gord Dibben MS Excel MVP