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
 
N

Nick Hodge

Quick and dirty...

=AVERAGE(T19:T499,T501:T1163,T1165:T1319,T1321:T1333)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word How to Exclude certain words from: COUNTIF 0
How do I exclude a cell from a range? 4
how do I average a range which also contains empty cells 2
Take an average of a range of cells but exlude blanks from that av 4
how do I perform a conditional average with exclusions? 5
How Do I create a formula for the percentage below? 4
How do I make a rank equation that omits particular cells? 1
How do I 'SUM' a column corrected to 2 decimal places from 3 2

Top