Conditional Product
Hi
XL-XP. I'm trying to create a cell formula (not UDF) that gives me the
product of all lines that are true, e.g.
A, True, 2
B, True, 3
C, False,4
D, True, 5
Would give 30 (2*3*5)
I can get the sum of these without a problem with the array formula
{=SUMPRODUCT((B1:B4=TRUE)*C1:C4)}
but cannot find a corresponding PRODUCT-PRODUCT formula.
Any help gratefully appreciated.
John
|