Multiple Criterion with Cross Sheets

Hello I am stumped. I have tried several different combinations to my formulas trying to get them to function. I get an #UNPARSEABLE error most of the time.

I have tried this formula =COUNTIFS({Complete Claim Status}, Status@row, {Vendor Name}, [Vendor Name]@row)

Complete Claim Status is the range on my cross sheet | Status@ row is from my main sheet

Vendor Name is the second range on my cross sheet | [Vendor Name]@row is from my main sheet and I have removed the brackets as well around that as well.

Here is a screenshot. Thank you for your assistance.

Find more posts tagged with

Formulas

Accepted answers

Mike TV

@Melanie S

=COUNTIFS({Complete Claim Status}, =Status@row, {Vendor Name}, =[Vendor Name]@row)

This formula worked for me. I set up 2 separate test sheets like so:

The 2nd sheet in the Count column is where I placed that formula. It's setup with cross-sheet references as so:

All comments

Mike TV

@Melanie S

Hi Melanie. You don't have your criterion formatted quite right. Try this:

=COUNTIFS({Complete Claim Status}, =Status@row, {Vendor Name}, =[Vendor Name]@row)

Melanie S

@Mike TV Thanks for your quick response. Unfortunately now I am getting another error.

Any ideas?

Mike TV

@Melanie S

=COUNTIFS({Complete Claim Status}, =Status@row, {Vendor Name}, =[Vendor Name]@row)

This formula worked for me. I set up 2 separate test sheets like so:

The 2nd sheet in the Count column is where I placed that formula. It's setup with cross-sheet references as so:

Melanie S

@Mike TV 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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.