SUMIFS Excel 97-2003 equivalent

chilisrool

New Member
Joined
Jan 30, 2014
Messages
34
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.
 

Some videos you may like

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
Joined
Oct 20, 2009
Messages
8,137
Office Version
  1. 365
Platform
  1. Windows
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
 

Dave Patton

Well-known Member
Joined
Feb 15, 2002
Messages
4,352
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
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))
 

Watch MrExcel Video

Forum statistics

Threads
1,114,255
Messages
5,546,794
Members
410,758
Latest member
Papers
Top