COUNTIF formula

M

Maxx

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!!!!
 
S

Shane Devenshire

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count Number of Unique Cells That Don't Have Certain Characters 0
countif 3
Excel Countif Function - Calculating Between Two Sets of Values 3
Need some help with a COUNTIF function 4
Finding the weighted average of text that have been given values 1
Need Help with a VBA subroutine 0
Countif formula perhaps 8
Using <= in countifs statement 1

Top