I have the following formula for a worksheet.
=IF(SUM('Daily Lates'!L8)=0,"",SUM('Daily Lates'!L8))
However, we want to add to this. We want to have a countif for Quit and for Injured along with the NS. If there are cells that say quit for the person we would like the cell to say N/A or NA. Is this possible? and if so, how do I do it?
=IF(SUM('Daily Lates'!L8)=0,"",SUM('Daily Lates'!L8))
However, we want to add to this. We want to have a countif for Quit and for Injured along with the NS. If there are cells that say quit for the person we would like the cell to say N/A or NA. Is this possible? and if so, how do I do it?