CODEWITHSUNDEEP
excelexcel-formula
Joe Blow
Joe Blow

Reputation: 1

Combining 2 arguments in COUNTIFS function and returning the total of both

I have a large data set that lists out spaces.

I want to count the number of cells containing the values "IT closets" and "Server Rooms" and then retrieve the combined total of both.

The data set has several variations for both i.e. IT Room, IT Closet, Server Room, Server Closet etc.

I was able to count the number of cells that contained the word “IT” by using the following formula:

=COUNTIFS('Spaces Grid'!C:C,"IT*")

So my question is how do I add to this formula to include cells that contain the word “Server*”, and return the combined total of both?

Upvotes: 0

Views: 435

Answers (2)

Christian Trujillo
Christian Trujillo

Reputation: 522

if you want it to count only the cells that contain "IT closets" and "Server Rooms", you can add 2 countif statements?

=COUNTIF('Spaces Grid'!C:C,"IT closets") + COUNTIF('Spaces Grid'!C:C,"Server Rooms")

let me know if I misunderstood the question

Upvotes: 0

JNevill
JNevill

Reputation: 50200

You could do something like:

=SUM(COUNTIFS('Spaces Grid'!C:C,{"it*","server*"}))

This looks for both matches and sums the results.

Upvotes: 1

Related Questions