View original (French)

Excel: How to count non-blank cells

Solved
Marine -  
 1864894 -
Hello,

I'm looking to count the number of non-null cells in a column. The COUNT() functions and variants count them all as long as none are empty... Do you have a solution?

Thank you!

Configuration: Windows Vista / Firefox 3.6.21

3 answers

  1.
    Raymond PENTIER Posted messages 58225 Registration date   Status Contributor Last intervention   17 488
     
    ... and even =COUNTIF(A1:A10,"<>0") if you might have negative values.

    Sincerely.
    --
    Retirement is great! Especially in the Caribbean ... :-)
    ☻ Raymond ♂
    32
    1. 1864894
       
      That's exactly what I was looking for, thank you!
      0