how to count/sum boolean data formula

Guilherme Ribeiro · 01/14/19

Hello my firends! How have you been?

Would be possible to have a logical formula to checks whether a bollean range and than return that sum of them.

for example: if I got two lines with 4 stars the formula should identify into the range both lines and returns 2 as total

Andrée Starå · 01/14/19

Hi Guilherme,

Try this.

=COUNTIF(Range:Range; ="Four")

The same version but with the below changes for your and others convenience.

=COUNTIF(Range:Range, ="Four")

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Comments