need help on a SUMIF formula to sum values if any of several drop down options are selected

I need a formula to sum all values in a column if that row has selected certain drop down menu options. The drop down menu is single select, but I am only interested in summing the values if the row has selected any of the first 6 options from the drop down menu.

Here are the options in the single select drop down menu:

1 - Prospect/discovery
2 - Negotiating LOI
3 - Executed LOI
4 - Due diligence
5 - Final negotiations
6 - Signed deal
7 - Closed deal
8 - Cancelled/lost
9 - Paused

I want to sum values from a column called # Physicians.

Find more posts tagged with

Formulas

Accepted answers

All comments

Shawn Church

Hi Morel,

If I understand your question correctly…you would use a sumifs function like this:

=sumifs([# Physicians]@row,[Deal Stage]@row,="1 - Prospect/discovery", [# Physicians]@row,[Deal Stage]@row,="2 - Negotiating LOI",etc,etc)

Then convert to a column formula

Hollie Green

You can use a Sumif(Or formula

=Sumif([Deal Stage]:[Deal Stage],Or(@cell="1 - Prospect/discovery",@cell="2 - Negotiating LOI",etc),[# Physician]:[# Physicians])

The etc would need to be replaced with the additional @cell="next option" until you have them all.

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.