Forum Discussion

Gunayathi's avatar
Gunayathi
Copper Contributor
Aug 31, 2020
Solved

Sum of a filtered data

Hello all,

 

I am struck with this query and it would be great if someone can help me with this issue in excel.

 

I have a data array in Sheet 2 Performace characteristics . In sheet 1 on a cell A3, I wanted the sum of a filtered data of column AT from sheet 2.

 

Filter data condition is FILTER('Performance Characteristics'!C:AX;('Performance Characteristics'!C:C=Sheet1!A3)*('Performance Characteristics'!U:U="FR"))

 

Can anyone help me,

 

Thanks.

BI & Data Analysis
excel
Excel for web
Formulas and Functions
office 365
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Aug 31, 2020

    Gunayathi If you only want to return the sum of filtered cells in column AT, try this:

    =SUM(FILTER('Performance Characteristics'!AT:AT;('Performance Characteristics'!C:C=Sheet1!A3)*('Performance Characteristics'!U:U="FR")))

1 Reply

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Aug 31, 2020

    Gunayathi If you only want to return the sum of filtered cells in column AT, try this:

    =SUM(FILTER('Performance Characteristics'!AT:AT;('Performance Characteristics'!C:C=Sheet1!A3)*('Performance Characteristics'!U:U="FR")))

Resources