Counting Values based on the contents of adjacent cell

Copper Contributor

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: Capture.PNG

4 Replies

@GasDetect 

Use SUMIF() or SUMIFS().

 

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

@GasDetect 

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, "=")

@GasDetect 

 

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,