Sum Formula that excludes other sum formula in range
 

I would like to put a sum formula that adds all the values in range but
excludes the cell that has other sum formula in it. Can someone help?

Thank You.

Sum Formula that excludes other sum formula in range
 

Look at the help file for info on the SUBTOTAL() function

A SUBTOTAL() that references a range in which there is another SUBTOTAL() is
smart enough to ignore the embedded function's value.


"Andy" wrote:

I would like to put a sum formula that adds all the values in range but
excludes the cell that has other sum formula in it. Can someone help?

Thank You.