Counting Values based on the contents of adjacent cell

Question

Good Day All!&nbsp;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&nbsp;been serviced.Units that have been serviced will have a note in the 'Service Status' column while the units that have not&nbsp;been serviced at will have no notes in the 'Service Status' column. I have 2 cells for each total respectively.&nbsp;&nbsp;How do I accomplish this?&nbsp;Please see the attached picture for reference:&nbsp;

detlef_lewin · Answer

GasDetect&nbsp;Use SUMIF() or SUMIFS().&nbsp;

gasdetect · Answer

I'm sorry, maybe I'm too inexperienced. But can someone please provide an example?

hansvogelaar · Answer

GasDetect&nbsp;
Assuming that the source data begin with the word Customer in A1:
Unit Served:
=SUMIFS(B2:B7, C2:C7, "&lt;&gt;")
Units Not Served:
=SUMIFS(B2:B7, C2:C7, "=")

mathetes · Answer

GasDetect&nbsp;&nbsp;maybe I'm too inexperienced. But can someone please provide an example?&nbsp;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,

Forum Discussion

Counting Values based on the contents of adjacent cell

Share

Resources