There are 12 values total; 6 entries each for Red and Blue.
All data is inExcel Tablenameddatain the range B5:C16.
This formula is a good example ofnestingone function inside another.
This is done with theTAKE function.
This is done with theSUM function.
TAKE returns the first 3 values to SUM:
And SUM returns 17 as a final result.
This is the sum of the first 3 quantities for “Red”.
The output from FILTER is dynamic.
If source data or criteria change, FILTER will return a new set of results.
The number of rows and columns to return is provided by separaterowsandcolumnsarguments.
Rows and columns can be extracted from the start or end of the given array.
SUM Function
The Excel SUM function returns the sum of values supplied.
These values can be numbers, cell references, ranges, arrays, and constants, in any combination.
SUM can handle up to 255 individual arguments.
