=SUMPRODUCT(--(C1:C10="a"),A1:A10)+SUMPRODUCT(--(C1:C10="a"),B1:B10)

but SUMIF works as well in your example

=SUMIF(C1:C10,"a",A1:A10)+SUMIF(C1:C10,"a",B1:B10)

--
HTH

Bob Phillips

"sumproduct if" <sumproduct wrote in message
...
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??