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