Collect Counts From Multiple Sheets

Happy Wednesday Smartsheet Community. I have another issue where I am attempting to collect system type counts from three multiple sheets. Unfortunately I have not been able to get the formula to accomplish this. Below is formula using to attempt the compilation

In the formula I am asking to pull from the P931 Admin Sheet, P931 F&B Sheet and the P931 Tech Warehouse Sheet where I select the System Type column to pull counts on all "Food Point of sale Indoor" system.

=COUNTIF({P931 - Admin Bldg - Deployment Device Count}, "Food Point of Sale Indoor"), ({P931 - F&B Warehouse - Deployment Device Count}, "Food Point of Sale Indoor"), ({P931 - Tech Warehouse - Deployment Device Count}, "Food Point of Sale Indoor"))

Below is example of sheet where I am attempting to pull the system type from. Each of the three sheets have this column. Just trying to build a formula that will reference all three sheets from this column and return the total collective count. I appreciate any and all help. Thank you.

Find more posts tagged with

Accepted answers

CodyRussell

Try this:

=COUNTIF({P931 - Admin Bldg - Deployment Device Count}, "Food Point of Sale Indoor") + countif({P931 - F&B Warehouse - Deployment Device Count}, "Food Point of Sale Indoor") + countif({P931 - Tech Warehouse - Deployment Device Count}, "Food Point of Sale Indoor")

All comments

CodyRussell

Try this:

RJT

Cody,

That worked perfectly. Thank you so much.

CodyRussell

Awesome, I'm glad that worked for you!

The issue was that your initial formula was a single countif, which you wanted to count and then sum three unique values.

Two ways to do this in the future would be a countifs formula, or by adding the values of individual count if statements like I did above(countif+countif+countif). :)

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