View original (French)

Excel, divide by number of filled cells

Solved
tonyynot -  
 tonyynot -
Hello,
.
Here's how to divide by the number of filled cells:
In a new cell, you can use the formula `=10/COUNTA(A1:A10)`.
This will divide 10 by the number of non-empty cells from A1 to A10, which in your example is 3.
.
Hope this helps!

2 réponses

Réponse 1 / 2
Mike-31 Posted messages 18405 Registration date   Status Contributeur Last intervention   5 145
 
Hello,

You can calculate the average directly
=AVERAGE(A1:A10)

Otherwise, to answer your question, you just need to sum it up
=SUM(A1:A10)/COUNTA(A1:A10)

=COUNTA(A1:A10) counts the number of filled cells

Best,
Mike-31

A period of failure is a perfect time to sow the seeds of knowledge.
34
Réponse 2 / 2
tonyynot
 
thank you resolved ;)
0