close
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.
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.quot;Andyquot; wrote:
gt; I would like to put a sum formula that adds all the values in range but
gt; excludes the cell that has other sum formula in it. Can someone help?
gt;
gt; Thank You.
全站熱搜
留言列表
