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...
There are couple of ways to do that. You may try these.
=SUM(CHOOSECOLS(A1#,3))
=SUM(INDEX(A1#,,3))
=SUM(INDEX(A1:D14,,3))
=SUM(IFERROR(A1#*{0,0,1,0},0))
many thanks!
