AGGREGATE & SUBTOTAL
Sum values excluding subtotals
Formula
Excel Formula – perform calculations & solve problems
Excel Formula – perform calculations & solve problems
Sum values excluding subtotals
Count the number of values
Count values that match my criteria
Finding my values counterpart
Sum values that match my criteria
Finding my values counterpart
Return my value if true
Finding my max & min values