Excel help required
I'm trying to sum a column that may include blank squares and then find the average of the values in the column not including the blank squares.
So add all the squares and then divide by the number of populated squares.
I'm sure there is a simple answer but I have GIYLF and had no success so far...
Posted By: caley canary, Oct 8, 17:16:30
Follow Ups
- get an accountant
Posted By: Tombs, Oct 8, 17:48:58 - This'll do it
Posted By: Old Git, Oct 8, 17:29:51 - This'll do it... just replace the example range with your range.
Posted By: sheffieldcanary, Oct 8, 17:26:53 - 1I'm not at a PC with Excel on...
Posted By: Mighty Boosh, Oct 8, 17:23:31 - Assuming there aren't too many cells to add up
Posted By: Worzel Scrimmage, Oct 8, 17:22:33 - 3=AVERAGE('first cell in range':'last cell in range' )
Posted By: blindasabat, Oct 8, 17:20:48
Reply to Message
Written & Designed By Ben Graves 1999-2025