Hello.

I came across a problem today and haven't found an easy way to solve it.
I have this formula:
=SUMIFS('Sheet 1'!H:H,'Sheet 1'!E:E,Sheet2!I4)+SUMIFS('Sheet 1'!H:H,'Sheet 1'!E:E,Sheet2!I5)+SUMIFS('Sheet 1'!H:H,'Sheet 1'!E:E,Sheet2!I6)+SUMIFS('Sheet 1'!H:H,'Sheet 1'!E:E,Sheet2!I7)
I'd like to make this formula smaller by doing something like this:
=SUMIFS('Sheet 1'!H:H,'Sheet 1'!E:E,OR(Sheet2!I4,Sheet2!I5,Sheet2!I6,Sheet2!I7))
But it doesn't work this way. Can I make something similar that will work?