Forum Discussion
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 bee...
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, "=")