I am attempting to have the functionality to be able to filter on the [BRAND] column and receive back the summed quantity of both Types (LEGACY and NPD).
#1 - I am using the subtotal formula above each month to sum the filtered months for that particular month.
I would now like to be able to filter on other columns and receive the total of the filter for the 2 TYPES listed below.
#2 - I am using the SUMIF formula to sum the different types of data provided in the TYPE column.
Notice that when I filter to the [CONVERSE] brand that the SUBTOTAL functionality works correctly but the SUMIF functionality does not ignore all the filtered fields as it keeps the same total even after filtering on the BRAND column.
Is it possible to make this happen??
#1 - I am using the subtotal formula above each month to sum the filtered months for that particular month.
I would now like to be able to filter on other columns and receive the total of the filter for the 2 TYPES listed below.
#2 - I am using the SUMIF formula to sum the different types of data provided in the TYPE column.
Notice that when I filter to the [CONVERSE] brand that the SUBTOTAL functionality works correctly but the SUMIF functionality does not ignore all the filtered fields as it keeps the same total even after filtering on the BRAND column.
Is it possible to make this happen??