Welcome!

This Post is Archived and Read-Only

The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.

Browse Active Topics

How to count number of flags in column?

tobrien3

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

Comments

Etienne Desbiens

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

Thanks!

J. Craig Williams

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.