View original (French)

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   -
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

3 answers

  1.
    Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    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!
    1
  3. hmcirta Posted messages 249 Registration date   Status Member Last intervention   23
     
    It's working very well!! ... Thank you!!
    0