Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF or SUM function (Multiple criteria) HELP!! | Excel Worksheet Functions | |||
SUMIF with multiple criteria | Excel Worksheet Functions | |||
Sumif with criteria list | Excel Worksheet Functions | |||
SUMIF multiple criteria in 1 range | Excel Worksheet Functions | |||
SUMIF multiple criteria | Excel Worksheet Functions |