Posted to microsoft.public.excel.worksheet.functions

Maxx

external usenet poster

Posts: 3

COUNTIF formula

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
CountIF and Sum in one formula?	Scott A[_2_]	Excel Worksheet Functions	8	June 4th 09 07:51 AM
CountIF Formula	Marilyn	Excel Discussion (Misc queries)	6	October 9th 06 09:32 PM
countif formula	japc90	Excel Discussion (Misc queries)	6	July 25th 06 11:28 PM
help in countif formula.	martin	Excel Discussion (Misc queries)	3	June 1st 06 10:21 AM
CountIf formula results in the formula itself being displayed.	NewKid	Excel Worksheet Functions	9	December 21st 05 11:10 PM

All times are GMT +1. The time now is 11:34 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us