Forum Discussion

rshenk3

Copper Contributor

Mar 30, 2023

Summing Split Filtered Values

Is it possible to SUM a list of SPLIT values that were compiled using the FILTER function, all in one formula?

excel

Formulas and Functions

rshenk3

Copper Contributor

Mar 30, 2023

Thank you for your reply!
This is the formula I tried using
=SUM(SPLIT((FILTER('Order Import'!X:X,'Order Import'!AD:AD=A14),",",FALSE)))

but it only returns the sum of the first cell in the filter. I would like it to return the sum of all the values returned by the FILTER function.

Harun24HR

Bronze Contributor

Mar 30, 2023

rshenk3 First clarify, are you Excel or google-sheet? SPLIT() is function of google-sheet, not excel. To split multiple values at a time you need to array formula. So, try-

=SUM(ArrayFormula(SPLIT((FILTER('Order Import'!X:X,'Order Import'!AD:AD=A14),",",FALSE))))