Hi,

I assume that A1:A9 is a typo and you mean A1:A8.

Try this

=SUMPRODUCT((A1:A8=A10)*(B1:D8))

Mike

"geebee" wrote:

hi,

i have a value in cell A10. i want to sum numbers in range B1:D8 where the
value in A10 value is equal to a value in range A1:A9. how can this be done?


thanks in advance,
geebee