CountIf or leave blank

[bcags7]

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

 

[Joe User]

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

 

[Bob Phillips]

Just use a format on the cell of

General;General;

HTH

Bob

 

[Jacob Skaria]

Right click on the formula cell and custom format as below

#