How to Count a value in a drop down / multi-selection list?

Hi,

I'm wanting to count the total amount time this value "VAVE" is being assigned to a drop down column. I'm using a summary sheet to collect this data using formulas.

So in the request type column(drop down list) I want the total in this sheet. I also want a total by the Brand.

I keep getting an incorrect number, like 48 or 0. The correct answer should be 6 total.

I've tried these formulas:

=COUNT({CPR Request Type}, "VAVE")

=COUNTIFS({CPR Request Type}, "VAVE")

Find more posts tagged with

Formulas

Accepted answers

Darren Mullen

@Shawn_K2 UGH I make a mistake. I copied your formula without looking at it close enough 😜

try =COUNTIFS({CPR Request Type}, HAS(@cell, "VAVE"))

Darren Mullen

@Shawn_K2

=COUNTIFS({CPR Request Type}, HAS(@cell, "VAVE"), {CPR Brand}, HAS(@cell, "ING"))

All comments

Darren Mullen

@Shawn_K2

Try this:

=COUNT({CPR Request Type}, HAS(@cell, "VAVE"))

That assumes that {CPR Request Type} represents the entire column in the sheet that you are referencing.

Read more about HAS(): https://help.smartsheet.com/function/has

Shawn_K2

Hey @Darren Mullen It is still counting too high. This came back with 48. The answer should be 6.

And yes {CPR Request Type} is the column.

Darren Mullen

@Shawn_K2 UGH I make a mistake. I copied your formula without looking at it close enough 😜

try =COUNTIFS({CPR Request Type}, HAS(@cell, "VAVE"))

Shawn_K2

@Darren Mullen That worked! Thank you!

Now if I want to do the same formula but also sort by the Brand column?

Darren Mullen

@Shawn_K2 Add a 2nd criterion range and criterion https://help.smartsheet.com/function/countifs

Shawn_K2

@Darren Mullen Getting the 0 again. I've tried to place the <> and I get 0 or errors.

=COUNTIFS({CPR Request Type}, HAS(@cell, {CPR Brand}, "ING"))

Darren Mullen

@Shawn_K2

=COUNTIFS({CPR Request Type}, HAS(@cell, "VAVE"), {CPR Brand}, HAS(@cell, "ING"))

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.