Re: sumproduct if

I knew that when Don posted his at 5:30 this morning, and I didn't see it in
my O.E. for some reason.
I kicked myself when I finally did see his.
Are you repeating it here so that I kick myself again?<vbg>

I wish these MS servers would get it all together, so that I could at least
put my foot in my mouth less often!

--
Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

"Bob Phillips" <phillips@xxxxxxxxxxxxx> wrote in message
news:#8zmL#iWFHA.1152@xxxxxxxxxxxxxxxxxxxxxxx
> or even more so
>
> =SUMPRODUCT((A1:A10="BUY")*(B1:C10))
>
>
> --
> HTH
>
> Bob Phillips
>
> "RagDyeR" <ragdyer@xxxxxxxxxxxxx> wrote in message
> news:OEkr7ciWFHA.616@xxxxxxxxxxxxxxxxxxxxxxx
> > A little more concise:
> >
> > =SUMPRODUCT((A1:A10="BUY")*((B1:B10)+(C1:C10)))
> > --
> >
> > Regards,
> >
> > RD
> > --------------------------------------------------------------------
> > Please keep all correspondence within the Group, so all may benefit !
> > --------------------------------------------------------------------
> >
> >
> > "papou" <cestpasbon@çanonplus44.fr> wrote in message
> > news:Om4DacfWFHA.3572@xxxxxxxxxxxxxxxxxxxxxxx
> > =SUMPRODUCT((A1:A10="BUY")*(B1:B10))+SUMPRODUCT((A1:A10="BUY")*(C1:C10))
> >
> > HTH
> > Cordially
> > Pascal
> >
> > "sumproduct if" <sumproduct if@xxxxxxxxxxxxxxxxxxxxxxxxx> a écrit dans
le
> > message de news: F569EFE9-1B6E-4190-8967-E223FF5902DA@xxxxxxxxxxxxxxxx
> > > can you give me an example? Say i have:
> > >
> > > A B C
> > > BUY 2 4
> > > BUY 4 8
> > > SELL 3 4
> > > BUY 5 2
> > >
> > > if i want to sumproduct columns B and C only where column A = "BUY",
> what
> > > would be the formula?
> > >
> > >
> > >
> > >
> > > "papou" wrote:
> > >
> > >> Hi
> > >> SUMPRODUCT will allow multi-criteria whereas SUMIF only allows one
> > >> criteria.
> > >> Now if I understand rightly, you have one criteria and several
columns
> to
> > >> add.
> > >> In which case you may add several SUMPRODUCT together.
> > >>
> > >> HTH
> > >> Cordially
> > >> Pascal
> > >>
> > >> "sumproduct if" <sumproduct if@xxxxxxxxxxxxxxxxxxxxxxxxx> a écrit
dans
> le
> > >> message de news:
AAA86B2C-DC4F-49EA-9E1E-52757861DB4C@xxxxxxxxxxxxxxxx
> > >> >i need a "sumproductif" function:, a combination of sumif and
> sumproduct
> > >> >
> > >> > e.g. i need to sumproduct values in columns A and B if a condition
in
> > >> > column
> > >> > C holds
> > >> >
> > >> > does anyone know of anything that would do this??
> > >> >
> > >> >
> > >> >
> > >> >
> > >>
> > >>
> > >>
> >
> >
> >
>
>


.