SUMIFS Excel 97-2003 equivalent

[chilisrool]

Can anyone help me with alternative formula for:

=SUMIFS('Player Seasons'!$F$2:$F$358,'Player Seasons'!$D$2:$D$358,"=REG",'Player Seasons'!$E$2:$E$358,$A2)

that will work in Excel 97-2003?

Thank you in advance.

 

[steve the fish]

Syntax will be like this:

=SUM(IF(A1:A2=1,IF(B1:B2=1,C1:C2)))

Where if A1:A1=1 and B1:B1 = 1 then it would sum C1:C2

Can you adapt that?

CSE not just enter

 

[chilisrool]

Thanks Steve. It worked great.

 

[Dave Patton]

Edit the following with your Sheet names.
This does not need to be array entered.

=SUMPRODUCT(--($D$2:$D$358="REG"),--($E$2:$E$358=$A2),($F$2:$F$358))

 

[chilisrool]

Thanks Dave. That seems like a more elegant solution to the problem.