COUNTIF Help

[jwconklin89]

I need some help on how to change the scope of what COUNTIF is counting. I am trying to set COUNTIF to count the entire column of only a table. The problem with it is that the table is never a set size sometimes it will have 10 entries and sometimes the table will have 50 entries. So my question is, how do I increase COUNTIF's range as more records are added to the table?

[bentleybob]

Can we assume that there's other information in the column that you don't want included?

One option would be to use a dynamic range name for your table.

[Fotis1991]

Hi and welcome to the forum.

You mean something like this??

=COUNTIF(A:A,"=1")

[daddylonglegs]

You could use a dynamic range within COUNTIF, e.g. if your table starts at C2 and entries are consecutive without blanks then you can define a range, e.g. Data - right-click and use "Name a Range" then use this formula in refers to:

=$C$2:INDEX($C$2:$C$1000,COUNTA($C$2:$C$1000))

that assumes you will never have more than 1000 rows, now use

=COUNTIF(Data,"x")

or similar

[jwconklin89]

Unfortunately I cant assume that nothing else will be put into that row, all i can do for the time being is make it dynamic and be sure to tell everyone not to use the E column for anything but that purpose. Thank you all very much for the help and the quick responses!!!