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