How to count crosses and starts

Hello,

I have a production chart where with times of 6am,9am,2pm,5pm,9pm,2am,4am. At any given time, under those boxes at any given time we can have a box labeled Start or Cross. I have created another sheet to track starts and crosses but how do I get it to automatically pull from my chart to the tracker? To clarify, if I had 4 starts for the day, and 7 crosses, how do I get that to translate to my tracker under starts and crosses each day of the week?

Chamber Status.PNG

Tracker.PNG

Find more posts tagged with

Accepted answers

Brett Smith

Hi @Diego Casillas Zaragoza ,

In your Tracker Sheet use a COUNTIF formula and the range component is referenced from your other sheet.

When you start typing your formula... =COUNTIF( select the 'Reference another sheet' link to reference your Chamber Status sheet, and then select the columns 6am - 4am as your reference.

Should look something like =COUNTIF({Chamber Status}, "Start") to count Starts, or =COUNTIF({Chamber Status}, "Cross") to count Crosses.

Looks like your tracker has a spot for each day of the week, and I'm unsure how you are doing that in your Chamber Sheet, but you will need different data for each day.

All comments

Brett Smith

Hi @Diego Casillas Zaragoza ,

In your Tracker Sheet use a COUNTIF formula and the range component is referenced from your other sheet.

When you start typing your formula... =COUNTIF( select the 'Reference another sheet' link to reference your Chamber Status sheet, and then select the columns 6am - 4am as your reference.

Should look something like =COUNTIF({Chamber Status}, "Start") to count Starts, or =COUNTIF({Chamber Status}, "Cross") to count Crosses.

Looks like your tracker has a spot for each day of the week, and I'm unsure how you are doing that in your Chamber Sheet, but you will need different data for each day.

Diego Casillas Zaragoza

Brett Smith! thanks so much! it helped!

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.