Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I use countif to count values excluding blank cells
I am trying to get the percentage of 1's in a column excluding blank cells
A B 1 1 0 2 1 1 3 4 0 I know the formula would be =countif(a1:a4,1) answer would be 2 but, how do I get the percent of the #1's with including blank cells. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I use countif to count values excluding blank cells
=countif(a1:a4,1)/count(a1:a4)
=count() returns the number of numbers in the range. Glenda wrote: I am trying to get the percentage of 1's in a column excluding blank cells A B 1 1 0 2 1 1 3 4 0 I know the formula would be =countif(a1:a4,1) answer would be 2 but, how do I get the percent of the #1's with including blank cells. -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I use countif to count values excluding blank cells
Okay, now what If I want to exclude the blank cell in a3
"Dave Peterson" wrote: =countif(a1:a4,1)/count(a1:a4) =count() returns the number of numbers in the range. Glenda wrote: I am trying to get the percentage of 1's in a column excluding blank cells A B 1 1 0 2 1 1 3 4 0 I know the formula would be =countif(a1:a4,1) answer would be 2 but, how do I get the percent of the #1's with including blank cells. -- Dave Peterson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I use countif to count values excluding blank cells
Since the cell is empty, it won't be included in the =countif() and it won't be
included in the =count(). In fact, all non-numeric entries would be excluded from the =count() portion. Am I missing something? Glenda wrote: Okay, now what If I want to exclude the blank cell in a3 "Dave Peterson" wrote: =countif(a1:a4,1)/count(a1:a4) =count() returns the number of numbers in the range. Glenda wrote: I am trying to get the percentage of 1's in a column excluding blank cells A B 1 1 0 2 1 1 3 4 0 I know the formula would be =countif(a1:a4,1) answer would be 2 but, how do I get the percent of the #1's with including blank cells. -- Dave Peterson -- Dave Peterson |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I use countif to count values excluding blank cells
I thought maybe something like:
=COUNTIF(A1:A4,A1)/COUNTA(A1:A4) "Glenda" wrote in message ... Okay, now what If I want to exclude the blank cell in a3 "Dave Peterson" wrote: =countif(a1:a4,1)/count(a1:a4) =count() returns the number of numbers in the range. Glenda wrote: I am trying to get the percentage of 1's in a column excluding blank cells A B 1 1 0 2 1 1 3 4 0 I know the formula would be =countif(a1:a4,1) answer would be 2 but, how do I get the percent of the #1's with including blank cells. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count if not blank... | Excel Discussion (Misc queries) | |||
count number of cells | Excel Worksheet Functions | |||
enter numbers in blank cells | Excel Worksheet Functions | |||
Count cells with specific values in the cells next to them? | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions |