| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Array Formula Not Working with Range with Formulas | Excel Discussion (Misc queries) | |||
| Formula to find first, second, third etc. value (range) | Excel Discussion (Misc queries) | |||
| Using a formula to create named range reference | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Hybrid Mode
