Posted to microsoft.public.excel.worksheet.functions

Baba

external usenet poster

Posts: 6

Using text as a criteria in Excel

I am trying to get a value in excel where the criteria that has to be
satisfied are text in nature, but I do not what to type the text in the
formula but the cell reference.

I have use Sumif, If & And but no joy.

I hoping someone will be able to help.

Thanks
Tunde

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
Need help on counting text within certain criteria	christinac	Excel Worksheet Functions	5	April 27th 06 01:09 PM
Matching Text with With Certain Criteria	SteveC	Excel Worksheet Functions	19	April 4th 06 11:08 AM
How do I count wildcard text meeting certain criteria in EXCEL?	cybermaksim	Excel Worksheet Functions	1	February 17th 06 03:03 AM
Part of text as criteria	irresistible007	Excel Worksheet Functions	2	November 24th 05 11:23 AM
Counting text criteria	Belinda	Excel Worksheet Functions	1	October 20th 05 10:43 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us