That should read.... greater than less than ""
=sum(A1:A20)/countif(A1:A20)lessthangreaterthan""
For some reason the signs didn't come out on my reply.
I hope this makes sense now!
Posted By: Mighty Boosh on October 8th 2008 at 17:26:34
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
- nope... (General Chat) - blindasabat, Oct 8, 17:25:22
- won't that count the blank cells and lower the average? (n/m) (General Chat) - Dave in France, Oct 8, 17:21:58
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.