Forum Discussion
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
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)
- Hi sivakumarrj,
Thanks for your reply. Can we squeeze formula length, Bcs i have around 200 Colum's
