SUMIF BASED ON MULTIPLE RANGE WITH SINGLE CRITERIA

Dear All, I need help to sort out Summing value based on single criteria with Multiple range selection. Thanks, TEED2019

excel

Formulas and Functions

sivakumarrj

Brass Contributor

Mar 03, 2023

TEED2019

It seems that needs formula for specific sum for each item number , for example item 1 appears two times means it should be 65 + 65. in that case you need to create all item number should be created with sumif

65	Item 1	Item2	Item3	Item4	Item5	Item6	Item7
65	Item3	Item3	Item2	Item2	Item4	Item4	Item5	Item 1	65
65	Item5	Item4	Item2					Item2	325
39	Item5							Item3	390
65	Item3	Item3		Item2		Item4		Item4	325
65	Item3							Item5	234
								Item6	65
								Item7	65

=SUMIF($B$2:$B$7,J3,$A$2:$A$7)+SUMIF($C$2:$C$7,J3,$A$2:$A$7)+SUMIF($D$2:$D$7,J3,$A$2:$A$7)+SUMIF($E$2:$E$7,J3,$A$2:$A$7)+SUMIF($F$2:$F$7,J3,$A$2:$A$7)+SUMIF($G$2:$G$7,J3,$A$2:$A$7)+SUMIF($H$2:$H$7,J3,$A$2:$A$7)

TEED2019

Copper Contributor

Mar 03, 2023

Hi sivakumarrj,

Thanks for your reply. Can we squeeze formula length, Bcs i have around 200 Colum's

Forum Discussion

SUMIF BASED ON MULTIPLE RANGE WITH SINGLE CRITERIA

Resources