How do I exclude cells from a formula?
Thanks for help on this:
I have a simple PERCENTAGE function for a column of figures:
=AVERAGE(T19:T1333)
However, I need to EXCLUDE from the percentage calculation three
specific cells in the column - T500, T1164, T1320.
I thought it would be easy to write the formula thus:
=AVERAGE(T19-T487+T513-T1151+T1177-T1333)
But no, that's not the answer.
There must be an easy, elegant method to doing this properly. Thanks!
Stephen
|