Forum Discussion

Alex2Orges's avatar
Alex2Orges
Copper Contributor
Sep 04, 2022
Solved

NB.SI With exclusions

Hi there ^^   I'm looking for a way to use the NB.SI function, But i'd need to exclude some cases.  Thoses are in the middle of the way, and it's annoying. I'm talking about the oranges one. If any...
  • HansVogelaar's avatar
    Sep 04, 2022

    Alex2Orges 

    For example:

     

    =NB.SI(B2:C2;">=4")+NB.SI(E2:G2;">=4")+NB.SI(I2:J2;">=4")

Resources