sumif with multiple conditions

[Slax]

Column A is Cities, Column B is States. Column C is Dollars. There
are 200 rows of information. I want to add the values in Column C if
the City is Wichita and the State is Kansas. Can sumif do this??

[Roberto]

=SUMPRODUCT(--(A2:A201="Wichita");--(B2:B201="Kansas");--(C2:C201))

Regard
Roberto

"Slax" <[email protected]> ha scritto nel messaggio
news:[email protected]...
: Column A is Cities, Column B is States. Column C is Dollars. There
: are 200 rows of information. I want to add the values in Column C if
: the City is Wichita and the State is Kansas. Can sumif do this??
:

[Bob Phillips]

=SUMPRODUCT(--(A1:A100="Wichita"),--(B1:B100="Kansas"),C1:C100)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Slax" <[email protected]> wrote in message
news:[email protected]...
> Column A is Cities, Column B is States. Column C is Dollars. There
> are 200 rows of information. I want to add the values in Column C if
> the City is Wichita and the State is Kansas. Can sumif do this??
>

[Ashish Mathur]

Hi,

While sumproduct is the most effective way of solving this problem, another
way of achieving the same result is by using an array formula (Ctrl+Shift+Del)

=sum(if((rangeA="Wichita")*(rangeB="Kansas"),rangeC))

Regards,

Ashish Mathur

"Slax" wrote:

> Column A is Cities, Column B is States. Column C is Dollars. There
> are 200 rows of information. I want to add the values in Column C if
> the City is Wichita and the State is Kansas. Can sumif do this??
>
>

[Dave Peterson]

I bet you meant ctrl-shift-enter (not Ctrl+Shift+Del).



Ashish Mathur wrote:
>
> Hi,
>
> While sumproduct is the most effective way of solving this problem, another
> way of achieving the same result is by using an array formula (Ctrl+Shift+Del)
>
> =sum(if((rangeA="Wichita")*(rangeB="Kansas"),rangeC))
>
> Regards,
>
> Ashish Mathur
>
> "Slax" wrote:
>
> > Column A is Cities, Column B is States. Column C is Dollars. There
> > are 200 rows of information. I want to add the values in Column C if
> > the City is Wichita and the State is Kansas. Can sumif do this??
> >
> >

--

Dave Peterson

[Slax]

Thanks to all of you. Works like a Champ!!!