I'm trying to simplify a Sumproduct formula but can't figure out how to do so. current formula is:
=SUMPRODUCT((H3:H100=$K$3)*(E3:E100="Dunkin")+(H3:H100=$K$3)*(E3:E100="t-bones")+(H3:H100=$K$3)*(E3:E100="hannafords")+(H3:H100=$K$3)*(E3:E100="starbucks")+(H3:H100=$K$3)*(E3:E100="lowes")+(H3:H100=$K$3)*(E3:E100="subway"),C3:C100),
have tried following , but with #VALUE error:
=SUMPRODUCT((H3:H100=$K$3)*(E3:E100={"Dunkin","t-bones","hannafords","starbucks","lowes","subway"}),C3:C100)
thank you for any help in the matter
=SUMPRODUCT((H3:H100=$K$3)*(E3:E100="Dunkin")+(H3:H100=$K$3)*(E3:E100="t-bones")+(H3:H100=$K$3)*(E3:E100="hannafords")+(H3:H100=$K$3)*(E3:E100="starbucks")+(H3:H100=$K$3)*(E3:E100="lowes")+(H3:H100=$K$3)*(E3:E100="subway"),C3:C100),
have tried following , but with #VALUE error:
=SUMPRODUCT((H3:H100=$K$3)*(E3:E100={"Dunkin","t-bones","hannafords","starbucks","lowes","subway"}),C3:C100)
thank you for any help in the matter