SUM of range..Except

Hi,

Does anyone know if its possible to do a sum of a range, with an exception

Example

I want to sum cells a2..a10, except cell a9

thanks in advance for any help.

This might be basic for your application, but you can always do something like:

=SUM(A1:A10)-A9

Let me know if that helps.

yep thanks for your help.

i appreciate it.

Glad I could help.