Averaging formula help, please.

R

rainman

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
 
D

David Coleman

Hi Rainman

The easiest way to do this would seem to be:

=(sum(c3:e10)+sum(c11:e11)) / {total number of entries} (i.e. manually
entering the formula for averaging numbers)

for example.

=(sum(c3:e10)+sum(c11:e11))/5

If the total number of entries is likely to change than you could use:

=(sum(c3:c10))+sum(c11:e11))/count(c3:e10)

Hope this helps

David
 
B

Bob Phillips

David,

I think there are 2 errors in your latter formula. It should read

=(SUM(C3:E10)+SUM(C11:E11))/COUNT(C3:E10)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

David Coleman said:
Hi Rainman

The easiest way to do this would seem to be:

=(sum(c3:e10)+sum(c11:e11)) / {total number of entries} (i.e. manually
entering the formula for averaging numbers)

for example.

=(sum(c3:e10)+sum(c11:e11))/5

If the total number of entries is likely to change than you could use:

=(sum(c3:c10))+sum(c11:e11))/count(c3:e10)

Hope this helps

David
Click to expand...
 
Top