Posted to microsoft.public.excel.misc

Doug Laidlaw Doug Laidlaw is offline

external usenet poster

Posts: 2

Countif indirect question

As an example I have numerical data in cells A1:A5 (12,0,1,7,2). In cell B1 I
have the number 3. Now in cell A6 I want to count the number of cells that
are greater than 3. The answer should be 2. The countif formula lets me put
=countif(A1:A5,3) but I want to have linked it cell B1 so I can change
the parameter. I am trying to do this with the Indirect function but I can
not figure it out. Thanks!

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
INDIRECT Question	OdAwG	Excel Discussion (Misc queries)	1	May 2nd 07 04:09 AM
INDIRECT Question I think	s boak	Excel Discussion (Misc queries)	4	May 4th 06 12:14 PM
Indirect question	saveas getting rid of formulas	Excel Discussion (Misc queries)	6	February 3rd 06 03:36 PM
indirect.ext question	Dave K	Excel Discussion (Misc queries)	0	December 14th 05 10:43 PM
INDIRECT WITH COUNTIF	Malcolm Austin	Excel Worksheet Functions	2	November 26th 04 07:50 PM

All times are GMT +1. The time now is 12:24 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us