Flora Edwards
asked on
SUMIFS formula with Wildcard does not work.
please see attached.
i need help to make my sumifs formula work.
i tried wrapping that PRODUCT range inside INDEX with "" so that it gets changed inside the formula to text format
my boss asked me explicitly use of SUMIFs and not SUMPRODUCT. becuase she does not know SUMPRODUCT and gets confused with it. ʅ_(ツ)_ʃ
EE.xlsx
i need help to make my sumifs formula work.
i tried wrapping that PRODUCT range inside INDEX with "" so that it gets changed inside the formula to text format
=SUMIFS(D2:D9,A2:A9,2011,INDEX(C2:C9&"",),"7*")
. but somehow it returns value error and did not work.my boss asked me explicitly use of SUMIFs and not SUMPRODUCT. becuase she does not know SUMPRODUCT and gets confused with it. ʅ_(ツ)_ʃ
EE.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER