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.