Forum Discussion
leoacquarone
Apr 18, 2021Copper Contributor
Help with array in a SUMIFS formula
Hi everyone, it is my first post in this community. I am trying to work with a very simple array formula as a criteria for a SUMIFS formula without success. My data is as bellow Col...
Subodh_Tiwari_sktneer
Apr 18, 2021Silver Contributor
You may try SUMPRODUCT instead which can handle array calculations.
As per the data in your sample file...
=SUMPRODUCT((A1:A4={"a","c"})*B1:B4)
Or you will have to wrap your existing formula with SUM function like this...
=SUM(SUMIFS(B1:B4,A1:A4,{"a","c"}))