Product if not equal to zero
Solved
hmcirta
Posted messages
249
Registration date
Status
Member
Last intervention
-
hmcirta Posted messages 249 Registration date Status Member Last intervention -
hmcirta Posted messages 249 Registration date Status Member Last intervention -
Hello,
It may seem obvious, but I'm stuck and I really can't figure out how to do it????
My question is the following ... How do you calculate the product of the non-zero values in a range of cells?
Thank you for your usual help.
Configuration: Android / Chrome 71.0.3578.141
It may seem obvious, but I'm stuck and I really can't figure out how to do it????
My question is the following ... How do you calculate the product of the non-zero values in a range of cells?
Thank you for your usual help.
Configuration: Android / Chrome 71.0.3578.141
3 answers
Hello
example for a range from A1 to A10
formula to enter as an array, by pressing Enter while holding down Ctrl and Shift
it should automatically display between curly braces in the formula bar
=PRODUCT(IF(A1:A10<>0;A1:A10))
best regards
--
The quality of the response mainly depends on the clarity of the question, thank you!
example for a range from A1 to A10
formula to enter as an array, by pressing Enter while holding down Ctrl and Shift
it should automatically display between curly braces in the formula bar
=PRODUCT(IF(A1:A10<>0;A1:A10))
best regards
--
The quality of the response mainly depends on the clarity of the question, thank you!
