Simplify this formula

[GyleMc]

=SUMIF(‘26 Daily’.G$222:G$374,"<"&B2,‘26 Daily’.B$222:B$374)+SUMIF(‘26 Daily’.G$222:G$374,"<"&B2,‘26 Daily’.E$222:E$374))

I was told I can use SUMPRODUCT instead of multiple SUMIF, but I can’t get it to work.

This formula has been modified and simplified, but I would still like to combine/simplify the 2 SUMIF statements.

[karolus]

=SUMPRODUCT(‘26 Daily’.G$222:G$374 < B2;‘26 Daily’.B$222:B$374)+SUMPRODUCT(‘26 Daily’.G$222:G$374<B2;‘26 Daily’.E$222:E$374)