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

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



"rainman" wrote in message
...
My friend is trying to create a spreadsheet that will average a section
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 by
the number of entries in c3:e10.

i hope that makes sense...currently he has 3 entries that total 11 and
the averagae is 3.67. he wants to add 1 to the total before averaging
so the total is 12 and the average is 4.

please email me with suggestions...Thanx.

rainman at friendlynet dot com


---
Message posted from http://www.ExcelForum.com/

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" wrote in message
...
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



"rainman" wrote in message
...
My friend is trying to create a spreadsheet that will average a section
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 by
the number of entries in c3:e10.

i hope that makes sense...currently he has 3 entries that total 11 and
the averagae is 3.67. he wants to add 1 to the total before averaging
so the total is 12 and the average is 4.

please email me with suggestions...Thanx.

rainman at friendlynet dot com


---
Message posted from http://www.ExcelForum.com/

Or a bit shorter:

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

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"Bob Phillips" skrev i en meddelelse
...
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)