Posted to microsoft.public.excel.worksheet.functions

bcags7

external usenet poster

Posts: 7

CountIf or leave blank

See formula below...if it doesn't find any cells that contain "*A", a zero is
entered in the cell. I would like the cell to remain blank if nothing is
found. Is this possible?

Thanks in advance

=COUNTIF($I$27:$BR$34,"*A")

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
Leave Blank if No Value	Linexe	Excel Discussion (Misc queries)	4	January 28th 10 11:57 AM
validation - do not leave blank	Wanna Learn	Excel Discussion (Misc queries)	2	January 22nd 09 02:15 PM
To leave the cell Blank	Steved	Excel Worksheet Functions	8	April 2nd 08 08:48 PM
Leave cell blank	Steved	Excel Worksheet Functions	7	April 19th 07 09:07 PM
To leave a blank cell	Steved	Excel Worksheet Functions	6	July 18th 06 03:37 AM

All times are GMT +1. The time now is 07:56 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us