View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
braitman braitman is offline
external usenet poster
 
Posts: 5
Default 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