So I'm trying to count a brands sales for google sheet but i couldn't because what i want is kinda strange sum orders value if brand is true but if there's 2 are true you divide on 2 if there are 3 you divide on 3 etc Thank you

CodePudding user response：

You can divide your value by :
COUNTIF([range];TRUE)

In your example, it'll be :
COUNTIF(E2:I2;TRUE)

So in D2 you'll have :
=1000/COUNTIF(E2:I2;TRUE)