Counting Values based on the contents of adjacent cell
Good Day All!
I have an equipment service board that I would like to count the number of units that have been serviced versus the number of units that have not been serviced.
Units that have been serviced will have a note in the ‘Service Status’ column while the units that have not been serviced at will have no notes in the ‘Service Status’ column. I have 2 cells for each total respectively.
How do I accomplish this?
Please see the attached picture for reference:
Good Day All! I have an equipment service board that I would like to count the number of units that have been serviced versus the number of units that have not been serviced.Units that have been serviced will have a note in the ‘Service Status’ column while the units that have not been serviced at will have no notes in the ‘Service Status’ column. I have 2 cells for each total respectively. How do I accomplish this? Please see the attached picture for reference: Read More