A
A
Artem Morozov2019-05-05 21:30:02
Google Sheets
Artem Morozov, 2019-05-05 21:30:02

How to count the number of flags for a period?

More recently, a new checkbox tool has been introduced in tables. Very comfortable. But it is not clear how to calculate the number of flags set for a period, for example, for a month. Some days they put it on, some days it doesn't. But how to use formulas to calculate how many checkboxes were checked in a month?
5ccf2b29cda27419888754.png

Answer the question

In order to leave comments, you need to log in

2 answer(s)
D
dollar, 2019-05-05
@artem-morozov

Checkboxes are essentially cells with two values: "TRUE" or "FALSE".
Therefore, we use the COUNTIF function, which counts the cells in a range with some condition. In your case it matches TRUE.
Formula:
Change the range, of course, to the one that corresponds to your conditional month.

N
Noir, 2019-05-05
@PolarBearGG

https://docs.google.com/spreadsheets/d/10OtO_ohWDc...

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question