Forum Discussion
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 ...
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")))
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")))