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
. 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. ʅ_(ツ)_ʃ