Adding up only the numbers that meet a specific criteria in another column

As stated in the titled above, I am trying to figure out how to do a formula that adds certain numbers together in a column, based on if the text in the column next to it, on the same row, is a certain value.

Example - Add Column B's Hours together (.5 +3 +6) but only if the column next to it in the same row says " Meetings".

Thanks for any and all advice/help!

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

You would want to look into the SUMIFS function.

=SUMIFS([Column to Sum]:[Column to Sum], [Criteria Column]:[Criteria Column], "criteria")

All comments

Paul Newcome

You would want to look into the SUMIFS function.

=SUMIFS([Column to Sum]:[Column to Sum], [Criteria Column]:[Criteria Column], "criteria")

Calen Fitzsimmons

Thank you Paul!

Thu Nghiem

Hi! Would this work the same for a COUNTIFS function? I want to count the number of rows that are not blank in one column when another column has a specific value.

Thank you!

Thu

Paul Newcome

@Thu Nghiem Yes it should.

=COUNTIFS([First Column]:[First Column], @cell <> "", [Second Column]:[Second Column], @cell = "specific value")

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.