How do I exclude cells from a formula?

B

braitman

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
 
Top