| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excluding subtotals from SUMIF function
I'm trying to use a SUMIF function on a column that includes SUBTOTAL
functions. The SUMIF seems to include the SUBTOTAL even though it doesn't match the criteria. Why? How can I can exclude the SUBTOTALs from the SUMIF? TIA, Graeme |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How i can create a formula that combine subtotals and sumif | Excel Worksheet Functions | |||
| Excluding Zero's from Average (SumIF / CountIF) | Excel Worksheet Functions | |||
| Min Function Excluding Zero Values & More | Excel Worksheet Functions | |||
| Excluding 0s and blanks from a LINEST function | Excel Worksheet Functions | |||
| Modify SUMIF and COUNTIF to work with SUBTOTALS | Excel Worksheet Functions | |||
Threaded Mode
