Excel expresion?

Man of Honour
Joined
11 Mar 2004
Posts
76,637
Is there an expression that works out how many boxes have data in it?

Basically I want to do a sum of a column divided by how many entries there are. However not every box has data in it. Is this possible?
 
Use Count ?

Count(rangestart:rangeend) should only give you the amount of cells which are not empty :)
 
Last edited:
Back
Top Bottom