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

How do I exclude cells from a formula?
 

Quick and dirty...

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"braitman" wrote in message
ups.com...
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

How do I exclude cells from a formula?
 

Try this:

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

Biff

"braitman" wrote in message
ups.com...
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

How do I exclude cells from a formula?
 

Ah, so it's the commas, not the plus signs. Doi! Thanks guys.