Sum(Sumifs)

[beginvbaanalyst]

Hi Everyone,

I'm current having an issue with a formula that should calculate the sum range based on multiple criterias.
=SUM(SUMIFS(_AP24[Updated Change],_AP24[Change V2],{"CM09","CM12","CM25","CM27"},_AP24[Product Code],{"CM05","CM07","CM08","CM10","CM13","CM14","CM15","CM28"}))

If i adjust the formula to the following all of a sudden the calculation works but I don't know why?
=SUM(SUMIFS(_AP24[Updated Change],_AP24[Change V2],{"CM25","CM09","CM12","CM27"},_AP24[Product Code],{"CM28","CM05","CM07","CM08","CM10","CM13","CM14","CM15"}))

if I place CM25 and CM28 to the front of the criteria it will sum my value. Is there a reason why it stops reading after those specific numbers?

 

[RoryA]

If you are going to use 2 array criteria (and you cannot use more with this approach) one must be 'horizontal' and the other 'vertical', so you need:

=SUM(SUMIFS(_AP24[Updated Change],_AP24[Change V2],{"CM09","CM12","CM25","CM27"},_AP24[Product Code],{"CM05";"CM07";"CM08";"CM10";"CM13";"CM14";"CM15";"CM28"}))

 

[beginvbaanalyst]

If you are going to use 2 array criteria (and you cannot use more with this approach) one must be 'horizontal' and the other 'vertical', so you need:

=SUM(SUMIFS(_AP24[Updated Change],_AP24[Change V2],{"CM09","CM12","CM25","CM27"},_AP24[Product Code],{"CM05";"CM07";"CM08";"CM10";"CM13";"CM14";"CM15";"CM28"}))

Totally right! Thank you for the help RoryA!

 

[RoryA]

Glad we could help.