Re: Multiple Criteria in a SUMIF or COUNTIF function
 From: "Max" <demechanik@xxxxxxxxx>
 Date: Thu, 29 Mar 2007 00:36:28 +0800
=SUMIF(NAME,"aname" .AND. TYPE,"atype",AMOUNT)
Try:
=SUMPRODUCT((NAME="aname")*(TYPE="atype"),AMOUNT)
The 3 defined ranges must be identically sized

Max
Singapore
http://savefile.com/projects/236895
xdemechanik

"Jack Gillis" <XXXXXXXX@xxxxxxxxxxxxx> wrote in message
news:%232bZ6WVcHHA.3648@xxxxxxxxxxxxxxxxxxxxxxx
I have a worksheet with three ranges with range names Amount,Name and Type.
I would like to write a SUMIF formula to give me the total based on two
criteria. . Amount is numeric and Type and Name are text. I have tried
something like this but keep getting an error.
=SUMIF(NAME,"aname" .AND. TYPE,"atype",AMOUNT) Clearly this doesn't work.
A pivot table is not an option in this case for several reasons.
=SUMIF(NAME,"aname",AMOUNT) yields the proper result.
Can someone help me out here?
Thank you very much.
.
 FollowUps:
 Re: Multiple Criteria in a SUMIF or COUNTIF function
 From: Jack Gillis
 Re: Multiple Criteria in a SUMIF or COUNTIF function
 References:
 Multiple Criteria in a SUMIF or COUNTIF function
 From: Jack Gillis
 Multiple Criteria in a SUMIF or COUNTIF function
 Prev by Date: Multiple Criteria in a SUMIF or COUNTIF function
 Next by Date: Re: sense conditional formating
 Previous by thread: Multiple Criteria in a SUMIF or COUNTIF function
 Next by thread: Re: Multiple Criteria in a SUMIF or COUNTIF function
 Index(es):
Relevant Pages
