How to count number of flags in column?

tobrien3 · 07/12/16

What formula would I use to count the number of flags that are up in a column?

Etienne Desbiens · 07/12/16

Hi,

Here is what you are looking for :

=COUNTIF([Column15]3:[Column15]12, 1)

If you want to write the result in the same column, simply add + "" at the end to prevent errors...

(=COUNTIF([Column15]3:[Column15]12, 1)+"")

Hope that helps,

Étienne

tobrien3 · 07/12/16

Thanks!

J. Craig Williams · 07/12/16

tobrien3

To get all of them, you'll need to modify Etienne's formula a bit.

Hers shows only 10 rows.

=COUNTIF([Column15]:[Column15], 1)

will show the count of the whole column -- you'll just need to put it in a different column.

Craig

Archived 2016 Posts