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 answers

  1.
    Mike-31 Posted messages 18405 Registration date   Status Contributor Last intervention   5 147
     
    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