I have a range of cells containing numbers 1-4 or some may have the letters "na". I am using a formula to count all the cells that contain a number and then multiply that number by another cell. Formula is:

=(COUNTIF(I5:CA5,">=0")-COUNTIF(I5:CA5,">=5"))*H5.

I have been asked not to include cell AC5 in that count and I don't know how to modify the formula to exclude that one cell.

I appreciate any help!!!! Thanks,

Makat