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")

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")

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")

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")