Dueling Excel 87


Positive Subtotals Only: PivotTable or SUMIFS

DESCRIPTION

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.

WORKBOOKS




Be the first to comment

Leave a Reply