| 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. |
| 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 | |||
Threaded Mode
