Unparseable Cross-sheet Formula

jprovateare

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

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!