SUMIF question with multiple criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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:$J278)>1,
'2005WCC'!$K$2:$K278=B5), '2005WCC'!$J$2:$J278)

Any help would be appreciated.

Thanks,
gretchen
 
Hi Gretchen

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

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


Regards

Roger Govier
 
Thanks Roger. Worked great.

gretchen

Roger Govier said:
Hi Gretchen

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

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


Regards

Roger Govier
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF with criteria "<>" & "=" 4
CountIF() & SumIF() with multiple criteria 5
What am I doing wrong with my =sumif ? 5
New 2007 Sumifs formula - is there a new multiple criteria vlookup 2
SUMIF Multiple Criteria in different ranges. 13
Multiple Criteria Sum 8
Multiple SUMIF criteria 1
how many duplicates in the one column 6

Back
Top