duane

Posts: n/a

how about this?

=COUNTA($c84:$d$99)-SUMPRODUCT((ISERROR(SEARCH(C65,$c$84:$d$99,1)))*1) +COUNTBLANK($C$84:$D$99)

--
duane

------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=382651

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 03:28 AM
Macro or Formula to remove Text from Cells	smck	Excel Worksheet Functions	6	May 11th 05 03:22 AM
Coverting Formula to Text	Catch 22	Excel Discussion (Misc queries)	3	April 1st 05 01:13 AM
How to insert carriage return in the middle of a text formula to .	Dave	Excel Discussion (Misc queries)	2	March 17th 05 02:14 PM
Concatenation formula loses text wrap formatting	DFM	Excel Discussion (Misc queries)	5	December 27th 04 01:45 PM

All times are GMT +1. The time now is 10:53 PM.

About Us

"It's about Microsoft Excel"