Answer the question
In order to leave comments, you need to log in
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?
Answer the question
In order to leave comments, you need to log in
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.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question