How to count number of flags in column?

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

Find more posts tagged with

Formulas

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

Thanks!

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