Averaging formula help, please.

  • Thread starter Thread starter rainman
  • Start date Start date
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
 
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
 
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...
 
Back
Top