CountIf or leave blank

  • Thread starter Thread starter bcags7
  • Start date Start date
B

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")
 
bcags7 said:
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.
Click to expand...

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


----- original message -----
 
Back
Top