Row with Multiple drop down choices and creating a summary

MelanieJohn

We have a Column on our Sheet which is a drop down list however more than one can be picked? Is there a way to as a summary to look for that field so that it sums it up?

Below are 2 which are in a row and chosen from the drop down

When we do the summary we would like this to be counted in both the IT Operations and Infra and the Sasser Strategic Services counts.

When I use the Count If function it wants me to lump the 2 together. Is there a different formula I can use that will pull if that is found in the column?

NicoLHC

@MelanieJohn 1. For if you choose drop you can change multi select here @picture.

2. Single Select works , sometime it helps FIRST MAKE the Formular in a Text Field then change to a drop down . =COUNTIF(Dep6:Dep17, "IT Operations")

Count =IT Operations	5	IT Operations Sasser
Count =Sasser	5	Sasser
		IT Operations Sasser
		Sasser
		Sasser
		Sasser
		Sasser
		IT Operations
		IT Operations
		IT Operations
		IT Operations
		IT Operations

NicoLHC

@MelanieJohn 1. For if you choose drop you can change multi select here @picture.

2. Single Select works , sometime it helps FIRST MAKE the Formular in a Text Field then change to a drop down . =COUNTIF(Dep6:Dep17, "IT Operations")

Count =IT Operations	5	IT Operations Sasser
Count =Sasser	5	Sasser
		IT Operations Sasser
		Sasser
		Sasser
		Sasser
		Sasser
		IT Operations
		IT Operations
		IT Operations
		IT Operations
		IT Operations

NicoLHC

@MelanieJohn

Part 3 Combinations : Multi Select

´=COUNTIF([Dropdown Column]:[Dropdown Column], HAS(@cell, "IT Operations"))

´=COUNTIF([Dropdown Column]:[Dropdown Column], HAS(@cell, "sasser"))

Count =IT Operations	0	IT Operations Sasser
Count =Sasser	0	IT Operations Sasser
		IT Operations Sasser
Multi
Count =IT Operations	3
Count =IT Operations	3

MelanieJohn

Thanks We do need them to be able to select multiple from the drop down as several teams may work on one issue. We just need the sum of that row to compute properly. We don't want to list the two teams in one chart on the graph as we are trying to show the number of projects which each team worked on.

NicoLHC

@MelanieJohn so is it resolved ? If you need the sum just combine Part 3 Formula

MelanieJohn

Yes that worked.. Thank you!

NicoLHC

@MelanieJohn great —additional TIP. if you want to to collect more data and show it in an Dashbaord you could use a metric sheet or simply a report ……