PaulFogel123
Member
Hello,
Can PRODUCT be used with criteria for which values can be in the array? In the attached file, I have a PRODUCT formula
=PRODUCT(C3:C7)^(1/COUNT(C3:C7))
that calculates a geometric mean from LOS in the table below.
MDC LOS
1 5.0
2 6.2
2 4.9
4 3.8
2 5.1
What if I want to only use LOS values in the array for both PRODUCT and COUNT that were MDC=2, for example? I could probably use COUNTIF for the second argument, but how would I modify the PRODUCT function? This is only a sample; the actual LOS column is thousands of rows deep and will change every moth.
Thanks for your help.
Paul
Can PRODUCT be used with criteria for which values can be in the array? In the attached file, I have a PRODUCT formula
=PRODUCT(C3:C7)^(1/COUNT(C3:C7))
that calculates a geometric mean from LOS in the table below.
MDC LOS
1 5.0
2 6.2
2 4.9
4 3.8
2 5.1
What if I want to only use LOS values in the array for both PRODUCT and COUNT that were MDC=2, for example? I could probably use COUNTIF for the second argument, but how would I modify the PRODUCT function? This is only a sample; the actual LOS column is thousands of rows deep and will change every moth.
Thanks for your help.
Paul