Countif for multiple columns

I am trying to count a score for multiple columns in a smartsheet summary. For some reason, it is only counting the first column if I use this:

=COUNTIF([Educational Background]:[Educational Background], COUNTIF([Prior Work Experience]:[Prior Work Experience]) = 5)

If I put the extra ) at the end, it makes it unparseable.

I'm not sure what I am doing wrong.

Find more posts tagged with

Formulas

Accepted answers

All comments

Austin Smith

@Chris Phillippe

Are you trying to use two criteria to filter your count so that it only counts the number of instances that there are 5s in each column? If so, that formula would be:

=countifs([Educational Background]:[Educational Background], =5, [Prior Work Experience]:[Prior Work Experience], =5)

If you're just wanting to add up the total score for the two columns:

=sum([educational background]@row, [prior work experience]@row)

If you only want to sum scores where PWE=5, try

=if([Prior Work Experience]@row=5, sum([educational background]@row, [prior work experience]@row),"")

If I missed the mark, let me know.

Chris Phillippe

Thank you for your help!

I tried your first solution, and it does count them, but the number is wrong. It was saying 17 and there are more than that in just one column.

I did find something online and it seems to be working well. (I added another column) =COUNTIF([Educational Background]:[Overall Impression and Recommendation], =5)

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.