Sum if multiple columns
Group Jan Feb Mar Group Sum
A 58 41 48 A #NAME?
A 37 46 32 B #NAME? Click to read article
A 38 48 38 C #NAME?
A 35 59 46
B 73 59 47
B 41 49 57 group = B5:B16
B 66 59 73 data = C5:E16
B 38 72 57
C 41 80 55 FILTER solution
C 30 51 74 SUMPRODUCT solution
C 75 30 53 Advanced criteria option
C 62 60 43 SUMIFS fail
Click to read article
Sum if multiple columns
Group Jan Feb Mar Group Sum
A 58 41 48 A 526
A 37 46 32 B 691 Click to read article
A 38 48 38 C 654
A 35 59 46
B 73 59 47
B 41 49 57 group = B5:B16
B 66 59 73 data = C5:E16
B 38 72 57
C 41 80 55 FILTER solution
C 30 51 74 SUMPRODUCT solution
C 75 30 53 Advanced criteria option
C 62 60 43 SUMIFS fail
Click to read article
Sum if multiple columns
Group Jan Feb Mar Group Sum
A01 58 41 48 A #NAME?
A02 37 46 32 B #NAME? Click to read article
A03 38 48 38 C #NAME?
A04 35 59 46
B01 73 59 47
B02 41 49 57 group = B5:B16
B03 66 59 73 data = C5:E16
B04 38 72 57
C01 41 80 55 FILTER solution
C02 30 51 74 SUMPRODUCT solution
C03 75 30 53 Advanced criteria option
C04 62 60 43 SUMIFS fail
Notice the Groups have
been alterned in a way that
makes them more difficult
to work with.
with SUMPRODUCT
Sum
526
Click to read article 691
654
Sum if multiple columns
Group Jan Feb Mar Group Sum
A 58 41 48 A Err:502
A 37 46 32 B Err:502 Click to read article
A 38 48 38 C Err:502
A 35 59 46
B 73 59 47
SUMIFS needs the range
B 41 49 57 group = B5:B16 and sum_range to be the
B 66 59 73 data = C5:E16 same size and will return
B 38 72 57 #VALUE! error if not.
C 41 80 55 FILTER solution
C 30 51 74 SUMPRODUCT solution
C 75 30 53 Advanced criteria option
C 62 60 43 SUMIFS fail
Click to read article
SUMIFS needs the range
and sum_range to be the
same size and will return a
#VALUE! error if not.
