Collect Counts From Multiple Sheets

RJT

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.

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")

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")

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). :)