This'll do it

Get a pen and paper, and write down all the numbers. Then add them up (you may use a calculator if you want) and divide by the number of numbers you wrote down.

Posted By: Old Git on October 8th 2008 at 17:29:51

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.