# SUMIFS Excel 97-2003 equivalent

#### chilisrool

##### New Member
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.

### Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

#### steve the fish

##### Well-known Member
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

##### New Member
Thanks Steve. It worked great.

#### Dave Patton

##### Well-known Member
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

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

Replies
23
Views
257
Replies
0
Views
40
Replies
7
Views
117
Replies
3
Views
34
Replies
7
Views
75

Threads
1,108,993
Messages
5,526,118
Members
409,685
Latest member
Bellybb