Forum Discussion
Summing a column in a filtered range
Hi all, If i use the FILTER functions and extract 4 (say) columns of data and the third column has numerical values then how to i add the values in the third column. See below. I know that a for...
= SUM(CHOOSECOLS(filteredArray#, 3))
or, combining the two formulas,
= SUM(CHOOSECOLS(FILTER(array, include), 3))
Many thanks!
