Posted to microsoft.public.excel.worksheet.functions

Robert Smith Robert Smith is offline

external usenet poster

Posts: 8

Countif formula problem

Hi folks,

Am doing a web query to pull down data. Worksheet can vary between 6 to 600 rows. Am trying to do a count of similar text names in column A. Text name to search is in cell J7. Download data will start on row 6.

I've tried =COUNTIF(A:A,J7) and get a result of zero. I've tried =COUNTIF(A$6:A$600,J7) and get a result of zero.

What am I doing wrong?

TIA,

Bob

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 Problem	Safi.	Excel Worksheet Functions	1	May 28th 08 03:52 PM
COUNTIF problem	mwam423	Excel Discussion (Misc queries)	13	May 16th 08 04:39 PM
Countif problem	Portocar	Excel Worksheet Functions	2	March 20th 08 06:48 PM
Countif Problem	John Moore	Excel Discussion (Misc queries)	5	November 27th 05 07:09 PM
Countif Problem	Alicia	Excel Worksheet Functions	3	November 4th 04 10:01 AM

All times are GMT +1. The time now is 09:13 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us