E

#### ericsh

conditions. I'm looking for a similar function that would multiply th

values. For instance, given the following data:

A B C

x 1 7 3

y 2 8 4

z 3 9 5

x 4 0 6

y 5 1 7

z 6 2 8

sumproduct((ABC="B")*(xyz="z"),values) = 11

I want something that will find the values that meet my conditions an

then multiplies them. In this case, Bz#1=9 and Bz#2=2, so the resul

would be 18.

Thanks,

Eri