SOLVED

Sum of a filtered data

%3CLINGO-SUB%20id%3D%22lingo-sub-1622445%22%20slang%3D%22en-US%22%3ESum%20of%20a%20filtered%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1622445%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20struck%20with%20this%20query%20and%20it%20would%20be%20great%20if%20someone%20can%20help%20me%20with%20this%20issue%20in%20excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20data%20array%20in%20Sheet%202%20Performace%20characteristics%20.%20In%20sheet%26nbsp%3B1%20on%20a%20cell%20A3%2C%3CU%3E%3CSTRONG%3E%20I%20wanted%20the%26nbsp%3Bsum%20of%20a%20filtered%20data%20of%20column%26nbsp%3BAT%20from%20sheet%202.%3C%2FSTRONG%3E%3C%2FU%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFilter%20data%20condition%20is%26nbsp%3BFILTER('Performance%20Characteristics'!C%3AAX%3B('Performance%20Characteristics'!C%3AC%3DSheet1!A3)*('Performance%20Characteristics'!U%3AU%3D%22FR%22))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20help%20me%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1622445%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1622465%22%20slang%3D%22en-US%22%3ERe%3A%20Sum%20of%20a%20filtered%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1622465%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F750027%22%20target%3D%22_blank%22%3E%40Gunayathi%3C%2FA%3E%26nbsp%3BIf%20you%20only%20want%20to%20return%20the%20sum%20of%20filtered%20cells%20in%20column%20AT%2C%20try%20this%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DSUM(FILTER('Performance%20Characteristics'!AT%3AAT%3B('Performance%20Characteristics'!C%3AC%3DSheet1!A3)*('Performance%20Characteristics'!U%3AU%3D%22FR%22)))%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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.

1 Reply
Highlighted
Best Response confirmed by Gunayathi (Occasional Visitor)
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")))