ExcelBanter - SUMIF question with multiple criteria

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - SUMIF question with multiple criteria (https://www.excelbanter.com/excel-worksheet-functions/54836-sumif-question-multiple-criteria.html)

Gretchster

SUMIF question with multiple criteria

I have the following formula written that isn't functioning properly:
=SUMIF('2005WCC'!B2:K278, AND(MATCH('2005WCC'!$B$2:$B278,{"State
Fund","Muirfield","Royal"},0)=1,('2005WCC'!$J$2:$J 278)1,
'2005WCC'!$K$2:$K278=B5), '2005WCC'!$J$2:$J278)

Any help would be appreciated.

Thanks,
gretchen

Roger Govier

SUMIF question with multiple criteria

Hi Gretchen

SUMIF won't take that many arguments.
One way would be

=SUMPRODUCT(--('2005WCC'!B2:B278="Muirfield"),--('2005WCC'!J2:J2781),--('2005WCC'!K2:K278=B5),'2005WCC'!J2:J278)

Regards

Roger Govier

Gretchster wrote:
I have the following formula written that isn't functioning properly:
=SUMIF('2005WCC'!B2:K278, AND(MATCH('2005WCC'!$B$2:$B278,{"State
Fund","Muirfield","Royal"},0)=1,('2005WCC'!$J$2:$J 278)1,
'2005WCC'!$K$2:$K278=B5), '2005WCC'!$J$2:$J278)

Any help would be appreciated.

Thanks,
gretchen

Gretchster

SUMIF question with multiple criteria

Thanks Roger. Worked great.

gretchen

"Roger Govier" wrote:

Hi Gretchen

SUMIF won't take that many arguments.
One way would be

=SUMPRODUCT(--('2005WCC'!B2:B278="Muirfield"),--('2005WCC'!J2:J2781),--('2005WCC'!K2:K278=B5),'2005WCC'!J2:J278)

Regards

Roger Govier

Gretchster wrote:
I have the following formula written that isn't functioning properly:
=SUMIF('2005WCC'!B2:K278, AND(MATCH('2005WCC'!$B$2:$B278,{"State
Fund","Muirfield","Royal"},0)=1,('2005WCC'!$J$2:$J 278)1,
'2005WCC'!$K$2:$K278=B5), '2005WCC'!$J$2:$J278)

Any help would be appreciated.

Thanks,
gretchen

All times are GMT +1. The time now is 10:37 AM.