How do i count checkboxes and divide on number?

Deedmunkee 0
Viewed 30

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

google-sheets
1 Answers

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)

user5l2i10
Related