COUNTIFS FORMULA REFERENCING ANOTHER SHEET HELP

Hi Guys, I have been trying to figure out why my formula is not working. I am referencing a sheet named LATE VENDOR DELIVERIES and looking at the columns in that sheet LOCATION # AND NAME and also CLAIM STATUS. I don't see where it references the other sheet in my formula so not sure if that is the problem.

=COUNTIFS({Location # and Name}:{Location # and Name},LOCATION@row,{Claim Status}:{Claim Status}, "Complete - Credit Received")

I get an #UNPARSEABLE error when I hit enter. Please help.

Find more posts tagged with

Accepted answers

Jeff Reisman

When you create a reference to a column in another sheet, the range name includes the entire column. Therefore, in your COUNTIFS, just putting {Location # and Name} as the range to search is enough. You don't need to put it in {Location # and Name}:{Location # and Name} format.

=COUNTIFS({Location # and Name}, LOCATION@row, {Claim Status}, "Complete - Credit Received")

Also make sure you add a space after commas.

All comments

Jeff Reisman

=COUNTIFS({Location # and Name}, LOCATION@row, {Claim Status}, "Complete - Credit Received")

Also make sure you add a space after commas.

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.