I've used the sumproduct function to add values the meet multiple
conditions. I'm looking for a similar function that would multiply the
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 and
then multiplies them. In this case, Bz#1=9 and Bz#2=2, so the result
would be 18.
Thanks,
Eric
--
ericsh
------------------------------------------------------------------------
ericsh's Profile:
http://www.excelforum.com/member.php...o&userid=26149
View this thread:
http://www.excelforum.com/showthread...hreadid=394775