Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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") |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CountIf or leave blank
"bcags7" wrote:
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. =IF(COUNTIF($I$27:$BR$34,"*A"), COUNTIF($I$27:$BR$34,"*A"), "") ----- original message ----- "bcags7" wrote: 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") |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CountIf or leave blank
Just use a format on the cell of
General;General; HTH Bob "bcags7" wrote in message ... 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") |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CountIf or leave blank
Right click on the formula cell and custom format as below
# -- Jacob "bcags7" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Leave Blank if No Value | Excel Discussion (Misc queries) | |||
validation - do not leave blank | Excel Discussion (Misc queries) | |||
To leave the cell Blank | Excel Worksheet Functions | |||
Leave cell blank | Excel Worksheet Functions | |||
To leave a blank cell | Excel Worksheet Functions |