View original (French)

MIN excluding 0

Solved
Coco-8 Posted messages 94 Status Member -  
 TPR1-KM -
Bonjour, I would like to execute the MIN function over a specific range of cells but I want it to ignore the cells that contain the value 0. Just like the AVERAGEIF function (MOYENNE.SI) does with criteria (“<>0”).

Example:
A1=5
A2=9
A3=0
A4=2

=MIN(A1:A4) = 2 and not 0.

3 answers

  1.
    diablo13800 Posted messages 3469 Registration date   Status Member Last intervention   1 872
     
    Hello,

    Use the following formula:

    =MIN(IF(A1:A4<>0,A1:A4))

    This is an array formula. Validate it using ctrl+shift+enter

    --
    To conquer without peril is to triumph without glory.
    Pierre Corneille, Le Cid
    18
    1. Coco-8 Posted messages 94 Status Member 2
       
      Thank you!
      0
    2. TPR1-KM
       
      Clear, concise, and effective explanation! Thank you!
      0