Unparseable Cross-sheet Formula

Hello!

I'm trying to create a Metrics sheet that will count the number of consumer contacts each month by brand so that I can eventually use them in a dashboard. Here's my cross sheet formula. It keeps coming back unparseable but I can't figure out why:

=COUNTIFS({Consumer Contacts Range 3}, MONTH:MONTH, "January", BRAND:BRAND, "Brand A")

I think it has something to do with the cross sheet reference because when I try this formula in the sheet summary, it works just fine (but I need to pull data from different sheets into a dashboard widget so summary won't work). I must be doing something wrong when referencing the sheet?

TIA

Find more posts tagged with

Accepted answers

All comments

DKazatsky2

Hi @jprovateare,

The formula should look something like this.

=COUNTIFS({Month},="January",{Brand},="Brand A")

with a cross-reference to month and brand.

Hope this helps,

Dave

jprovateare

Aha! I understand now and I got it. Thank you!

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.