COUNTIFS formula for criteria in two columns in another sheet not working

I am counting how many ads are live out of how many total and I'm unable to get the COUNTIFS formula to work. The cell should reference another sheet and count how many ads are live in each category.

The formula I'm using is coming up unparesable even though I referenced Smartsheet's many help pages on this topic. What am I doing wrong?

=COUNTIFS({6. Ad Placement Tracker Range 1}:{6. Ad Placement Tracker Range 1}, 1, {6. Ad Placement Tracker Range 2}:{6. Ad Placement Tracker Range 2},"eNewsletter"})

Find more posts tagged with

Formulas

Marketing

Accepted answers

Paul Newcome

When using a cross sheet reference, you only enter it once.

=COUNTIFS({Cross Sheet Reference}, @cell = "Text")

When you set up the cross sheet reference, you would click on the column header to select the entire column and that is built into the reference automatically.

All comments

Paul Newcome

When using a cross sheet reference, you only enter it once.

=COUNTIFS({Cross Sheet Reference}, @cell = "Text")

When you set up the cross sheet reference, you would click on the column header to select the entire column and that is built into the reference automatically.

SarahBKarna

@Paul Newcome THANK YOU!

Paul Newcome

Happy to help. 👍️

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.