• Notice regarding image hosts and attachments. See here.

Excel expresion?

Man of Honour
Joined
11 Mar 2004
Posts
76,678
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