COUNTIFS & AND + <>

Hello,

I appreciate your help in fixing this formula. I want to exclude from counting any blank cell for one column & any cell with "Center" from another column. The one for excluding "Center" is not working.

=COUNTIFS(AND([Deliverable(s)]3:[Deliverable(s)]137, <>"", [Responsible Party]3:[Responsible Party]147, <>"Center"))

Thank you in advance.

Find more posts tagged with

Formulas

Accepted answers

Darren Mullen

@maltaee Not the right syntax. Needs range and range criterion pairs. All you have is one AND statement.

Get rid of the AND(). COUNTIFS() will ensure all the criteria are true before counting. COUNTIFS()

All comments

Darren Mullen

@maltaee Not the right syntax. Needs range and range criterion pairs. All you have is one AND statement.

Get rid of the AND(). COUNTIFS() will ensure all the criteria are true before counting. COUNTIFS()

maltaee

I removed AND and it is working now. Thank you.

P.S. I tried getting Smartsheet 7 tips but the submission won't get me anywhere or send me the tips.

Darren Mullen

@maltaee Glad that worked for you. Thanks for the heads up about the 7 tips. It should be fixed now.

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.