Posted to microsoft.public.excel.programming

Sabosis

external usenet poster

Posts: 47

IF/AND statement with a Countif included

Hello

I need a formula that can validate a cells contents and also do a count in a range to show me if that range is empty. What is the easiest way?

=if(and((A2="TT",Countif(a5:A8,0),"YES,""))) ....this obviously doesn't work but it is what I am trying to accomplish.

Thanks in advance for any help on how to achieve this

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 within and if statement	Amber	Excel Worksheet Functions	2	July 30th 07 06:05 PM
countif statement	italiavb	Excel Worksheet Functions	4	July 14th 06 01:57 PM
If Statement with Countif	Crazyhorse	Excel Discussion (Misc queries)	3	April 10th 06 08:55 PM
Countif statement	Steved	Excel Worksheet Functions	11	September 28th 05 10:10 PM
Can Excel cell formatting be included in an IF statement?	neeses	Excel Worksheet Functions	3	September 21st 05 07:42 PM

All times are GMT +1. The time now is 02:48 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us