Dueling Excel 87

Positive Subtotals Only: PivotTable or SUMIFS


See Mr Excel and excelisfun use two methods to add only the subtotals that are positive (ignore negative Subtotals using PivotTable Pivot Table or SUMIFS or SUMPRODUCT functions. Aldo see how to do an approximate match or criteria in SUMIFS using a wild card. See the Functions ISBLANK, ISNUMBER and SEARCH.


Be the first to comment

Leave a Reply