E
ericsh
I've used the sumproduct function to add values the meet multipl
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
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