Sum of a filtered data

[Gunayathi]

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.

[#2 · Accepted solution]

@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")))