SOLVED

NB.SI With exclusions

Copper Contributor

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 anyone can help me, I'd be gratfull ;)

Alex2Orges_0-1662274447194.png

 

1 Reply
best response confirmed by Alex2Orges (Copper Contributor)
Solution

@Alex2Orges 

For example:

 

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

1 best response

Accepted Solutions
best response confirmed by Alex2Orges (Copper Contributor)
Solution

@Alex2Orges 

For example:

 

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

View solution in original post