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 on October 8th 2008 at 17:16:30

Message Thread

Excel help required (General Chat) - caley canary, Oct 8, 17:16:30
- get an accountant (General Chat) - Tombs, Oct 8, 17:48:58
- This'll do it (General Chat) - Old Git, Oct 8, 17:29:51
- This'll do it... just replace the example range with your range. (General Chat) - sheffieldcanary, Oct 8, 17:26:53
- I'm not at a PC with Excel on... (General Chat) - Mighty Boosh, Oct 8, 17:23:31
  - That should read.... greater than less than "" (General Chat) - Mighty Boosh, Oct 8, 17:26:34
- Assuming there aren't too many cells to add up (General Chat) - Worzel Scrimmage, Oct 8, 17:22:33
- =AVERAGE('first cell in range':'last cell in range' ) (n/m) (General Chat) - blindasabat, Oct 8, 17:20:48
  - won't that count the blank cells and lower the average? (n/m) (General Chat) - Dave in France, Oct 8, 17:21:58
    - nope... (General Chat) - blindasabat, Oct 8, 17:25:22
      - Cheers Blinders - worked a treat. (General Chat) - caley canary, Oct 8, 17:34:34

Reply to Message

In order to add a post to the WotB Message Board you must be a registered WotB user.

If you are not yet registered then please visit the registration page. You should ensure that their browser is setup to accept cookies.