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

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
Joined
Oct 20, 2009
Messages
8,110
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,239
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,108,993
Messages
5,526,118
Members
409,685
Latest member
Bellybb

This Week's Hot Topics

Top