B
Black9Medic
Hi,
I am creating an efficiency report and I am stuck on a problem. I am
getting a false statement when all the cells have no information in it when I
actually need that cell to remain blank when there is nothing to report.
Here is the formula I am using: =IF(COUNT(A39:C39),AVERAGE(A39:C39))
I am creating an efficiency report and I am stuck on a problem. I am
getting a false statement when all the cells have no information in it when I
actually need that cell to remain blank when there is nothing to report.
Here is the formula I am using: =IF(COUNT(A39:C39),AVERAGE(A39:C39))