# Counting Values based on the contents of adjacent cell

Copper Contributor

# 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:

4 Replies

# Re: Counting Values based on the contents of adjacent cell

Use SUMIF() or SUMIFS().

# Re: Counting Values based on the contents of adjacent cell

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

# Re: Counting Values based on the contents of adjacent cell

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

# Re: Counting Values based on the contents of adjacent cell

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,