ExcelBanter - COUNTIF formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - COUNTIF formula (https://www.excelbanter.com/excel-worksheet-functions/234349-countif-formula.html)

I have a spreadsheet with over 30,000 rows. I am am trying to use the COUNTIF
formula to count the number of cells with specific text, but it doesn't seem
to be working. Is there a limit on the number of cells that excel can
process? Do the cells have to be formatted a certain way in order to be
counted in the formula? Please help!!!!

Post your formula

--
Biff
Microsoft Excel MVP

"Maxx" wrote in message
...
I have a spreadsheet with over 30,000 rows. I am am trying to use the
COUNTIF
formula to count the number of cells with specific text, but it doesn't
seem
to be working. Is there a limit on the number of cells that excel can
process? Do the cells have to be formatted a certain way in order to be
counted in the formula? Please help!!!!

Hi,

30,000 is not a limit for this function. In 2003 you are limited to 65,536
rows and in 2007 the COUNIF can work with a maximum of 1,048,576 rows.

What does your data look like and what exactly is the formula?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"Maxx" wrote:

I have a spreadsheet with over 30,000 rows. I am am trying to use the COUNTIF
formula to count the number of cells with specific text, but it doesn't seem
to be working. Is there a limit on the number of cells that excel can
process? Do the cells have to be formatted a certain way in order to be
counted in the formula? Please help!!!!