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" wrote in message
...
or even more so

=SUMPRODUCT((A1:A10="BUY")*(B1:C10))


--
HTH

Bob Phillips

"RagDyeR" wrote in message
...
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" wrote in message
...
=SUMPRODUCT((A1:A10="BUY")*(B1:B10))+SUMPRODUCT((A 1:A10="BUY")*(C1:C10))

HTH
Cordially
Pascal

"sumproduct if" <sumproduct a écrit dans
le
message de news: ...
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 a écrit
dans
le
message de news:
...
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??