Aug 31 2020 02:33 AM
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.
Aug 31 2020 02:51 AM
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")))