sir Lancelot

Posts: n/a

formula that compares different ranges

I need a formula that finds criteria in a range if a different range contains
text data.
I already use countif
EXAMPLE:
=countif(g4:g51,".")
now I need that formula to work only if (D4:D51) contains text data.

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
IF formula?	meris	Excel Worksheet Functions	1	September 6th 05 07:14 AM
formula to show ranges in columns	Lori	Excel Worksheet Functions	7	May 23rd 05 12:44 PM
Match / Vlookup within an Array formula	Hari Prasadh	Excel Discussion (Misc queries)	3	February 3rd 05 04:37 PM
revert formula insertion to old method	Don't be a pain in the ass	Setting up and Configuration of Excel	0	January 24th 05 01:49 PM
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula?	Arvi Laanemets	Excel Discussion (Misc queries)	0	December 2nd 04 11:29 AM

All times are GMT +1. The time now is 04:05 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us