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