Bassman,

=SUMPRODUCT((A1:A10="t")*(B1:B10="t")*((C1:C10="x" )+(C1:C10="y"))*D1:D10)

HTH,
Bernie
MS Excel MVP


"Bassman62" wrote in message
...
Using xl-2007
I reallize that the OR statement cannot be used as an array in a Sumproduct.
In this case how can I sum the values in column D or count the rows where columns A & B = t and
column C = x Or y?

A B C D
1 t t x 10
2 t f x 5
3 t t y 10

Thanks.