19 Dec 2008 at 10:45 #1 Glaucus Glaucus 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?
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?
19 Dec 2008 at 10:55 #2 kevpuk kevpuk Soldato Joined 12 Jul 2005 Posts 3,005 Location Just over your shoulder Use Count ? Count(rangestart:rangeend) should only give you the amount of cells which are not empty Last edited: 19 Dec 2008
19 Dec 2008 at 11:02 #3 Glaucus Glaucus Man of Honour OP Joined 11 Mar 2004 Posts 76,637 Thank you very much .. As you can tell I never use excel..
19 Dec 2008 at 18:40 #4 kevpuk kevpuk Soldato Joined 12 Jul 2005 Posts 3,005 Location Just over your shoulder np