Hi guys, im a first time poster here and would like to seek help from you guys on a formula that i am working on. I have a problem having the SUMIFS formula listed below to return the combined value of "SX" plus "BX" plus "HX". All i get is whichever value that i have placed in front, in this case is "SX", and all other criterias behind are kinda ignored. how can i fix this formula?
=SUMIFS(MCG650R1!$K:$K,MCG650R1!$A:$A,'Offshelf Performance (Overall)'!$U10,MCG650R1!$E:$E,"2012",MCG650R1!$D:$D,{"SX","HX","BX"})
Thanks in advance.
Bookmarks