# 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?

### Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

#### 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

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
406
Replies
4
Views
80
Replies
0
Views
100
Replies
7
Views
139
Replies
3
Views
38