SUMIF question

I have a formula that attempts to use SUMIF to sum a range that includes two
columns.

=SUMIF(C3:C500,C3,D3:E500)

The result of this formula is the sum of column D only.
I had to break it down as follows:

=SUMIF(C3:C500,C3,D3:D500)+SUMIF(C3:C500,C3,E3:E500)

Is this normal behavior or is something wrong?

--Carlos

Yes it is normal behaviour, in SUMIF the corresponding sum range needs to be
of the same size, you can use

=SUMPRODUCT((C3:C500=C3)*(D3:E500))


--

Regards,

Peo Sjoblom



"CarlosAntenna" <nunayo@binnez.com> wrote in message
news:u334X1bGFHA.1740@TK2MSFTNGP09.phx.gbl...
> I have a formula that attempts to use SUMIF to sum a range that includes
two
> columns.
>
> =SUMIF(C3:C500,C3,D3:E500)
>
> The result of this formula is the sum of column D only.
> I had to break it down as follows:
>
> =SUMIF(C3:C500,C3,D3:D500)+SUMIF(C3:C500,C3,E3:E500)
>
> Is this normal behavior or is something wrong?
>
> --Carlos
>
>

Thanks Peo, I have never used SUMPRODDUCT before but there is always a first
time. This must be it.

-- Carlos

"Peo Sjoblom" <terre08@mvps.org> wrote in message
news:Ou4f2%23bGFHA.2736@TK2MSFTNGP12.phx.gbl...
> Yes it is normal behaviour, in SUMIF the corresponding sum range needs to
be
> of the same size, you can use
>
> =SUMPRODUCT((C3:C500=C3)*(D3:E500))
>
>
> --
>
> Regards,
>
> Peo Sjoblom
>
>
>
> "CarlosAntenna" <nunayo@binnez.com> wrote in message
> news:u334X1bGFHA.1740@TK2MSFTNGP09.phx.gbl...
> > I have a formula that attempts to use SUMIF to sum a range that includes
> two
> > columns.
> >
> > =SUMIF(C3:C500,C3,D3:E500)
> >
> > The result of this formula is the sum of column D only.
> > I had to break it down as follows:
> >
> > =SUMIF(C3:C500,C3,D3:D500)+SUMIF(C3:C500,C3,E3:E500)
> >
> > Is this normal behavior or is something wrong?
> >
> > --Carlos
> >
> >
>
>