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 réponses

Réponse 1 / 3
Raymond PENTIER Posted messages 58550 Registration date   Status Contributeur Last intervention   17 475
 
... and even =COUNTIF(A1:A10,"<>0") if you might have negative values.

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