Hello! My question is the same with Ron's, but I would like to exclude the cell that contains the formula that calculates the average. This cell will change every week (a row down) . How can I do this?
Thank you in advance for your answer! ;)
Quote:
Originally Posted by Ron Rosenfeld
On Sat, 23 Feb 2008 08:39:01 -0800, Steph
wrote:
I would like to write a formula that sums the values in cells A1:A5 while
excluding the value in cell A3 only.
For example:
A1 = 2
A2 = 6
A3 = 6
A4 = 2
A5 = 2
The formula would return 12. If the value in A3 changes to 10, the formula
would still return 12.
Thanks again for your help. And thanks to those who helped me with my
earlier post.
=a1+a2+a4+a5
--ron
|