Forum Discussion

peteryac60's avatar
peteryac60
Iron Contributor
Sep 15, 2026

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...
excel
Terio's avatar
Terio
Brass Contributor
Sep 16, 2026

The previous solutions are very good, but an alternative based on column name is a double filter as:

=SUM(FILTER(A2#,A1:D1="Local Currency",0))

or using XLOOKUP:

=SUM(XLOOKUP("Local Currency",A1:D1,A2#,0))

or more simply:

=SUM(A2#*(A1:D1="Local Currency"))


Bye

  • peteryac60's avatar
    peteryac60
    Iron Contributor
    Sep 16, 2026

    thanks for the solutions!