Sum Formula that excludes other sum formula in range

A

Andy

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.
 
D

Duke Carey

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.
 
Top