| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - calculating a percentage
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel - calculating a percentage
=COUNTIF(A1:A5,"Pass")/COUNTA(A1:A5) anf format as percentage.
Alter the range A1:A5 as appropriate. -- David Biddulph "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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel - calculating a percentage
=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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel - calculating a percentage
Excellent David, thank you very much. The first part works fine but because
some of the cells within the column are blank the second part of the formula doesn't work. The cells within the column will either have Pass, Fail or it could be blank Big G "David Biddulph" wrote: =COUNTIF(A1:A5,"Pass")/COUNTA(A1:A5) anf format as percentage. Alter the range A1:A5 as appropriate. -- David Biddulph "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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel - calculating a percentage
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel - calculating a percentage
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Excel Function for max of percentage or dollar amount | Excel Worksheet Functions | |||
| Excel file with hyperlinks takes a long time to open over the network | Links and Linking in Excel | |||
| function wizard excel 2000 not calculating in worksheet | Excel Worksheet Functions | |||
| Excel formula that calculates percentage of increase or decrease | Excel Worksheet Functions | |||
Linear Mode
