May 09 2024 09:27 AM
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:
May 09 2024 09:44 AM
May 10 2024 06:37 AM
May 10 2024 07:14 AM
Assuming that the source data begin with the word Customer in A1:
Unit Served:
=SUMIFS(B2:B7, C2:C7, "<>")
Units Not Served:
=SUMIFS(B2:B7, C2:C7, "=")
May 10 2024 08:57 AM
maybe I'm too inexperienced. But can someone please provide an example?
Here's a link to a resource that you should bookmark and refer to as you continue to learn. This link is directly to the SUMIF function, but the website deals with all Excel capabilities and has good examples to go with them,