Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Averaging formula help, please.
My friend is trying to create a spreadsheet that will average a sectio
of cells, but he wants to add a number to the total, before averaging and only average by the original number of cells. example...=average(c3:e10) is what he has, but he wants it to average c3:e10 and add c11:e11 but only average b the number of entries in c3:e10. i hope that makes sense...currently he has 3 entries that total 11 an the averagae is 3.67. he wants to add 1 to the total before averagin so the total is 12 and the average is 4. please email me with suggestions...Thanx. rainman at friendlynet dot co -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create an Averaging Formula | Excel Discussion (Misc queries) | |||
formula for selecting ans averaging | New Users to Excel | |||
problem with an averaging formula | Excel Discussion (Misc queries) | |||
Averaging formula error | Excel Discussion (Misc queries) | |||
Averaging with a formula | Excel Discussion (Misc queries) |