Sum Formula that excludes other sum formula in range

G

Guest

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

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF AND Nested Functions - Formula Not Working 0
Dsum Help 0
Excel formula, sum the value cell and if empty cell left blank 0
total a column in which there are sum formula 4
Sum every Nth Row (almost working) 1
Sum Postitive Values 5
Automatic update to SUM formula cell references. 6
Excel - IF formula with range of cells 2

Top