View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenda
 
Posts: n/a
Default 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.