Count from another sheet

Hi,

I have 2x sheets OTIF-Sept and Report I am trying to Count the total KER -111111 orders and is incremented by 1 every new order.

The count would count all orders in the Sept sheet so on a spare line if I use the following formula

=COUNT([Order Number]:[Order Number]) I get the value I require.

But if I run the below on the Reports sheet I get #UNPARSEABLE

=COUNT({OTIF-Sept Range 3},[Order Number]:[Order Number])

Can anyone explain the reason or what is wrong with the above formula.

Thanks Hargreaves

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

Set your cross sheet reference by only clicking on the column header for the column you want to count. It should look more like this:

=COUNT({OTIF-Sept Range 3})

Hargreaves

I have set up my cross reference as I have another 2 cross references that point to the same sheet hence the

=COUNT({OTIF-Sept Range 3},[Order Number]:[Order Number]) Order Number is the primary cell in that sheet.

Hargreaves

Thanks Paul,

I have sorted it.

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