COUNTIFS function across sheets
Hi there, I am trying to count th: ree separate columns in my sheet.
I tried the below in my sheet summary which gives me back 72 items, that I cross referenced by using filters in the sheet which looks correct
=COUNTIFS([Is active]:[Is active], "Yes", Tier:Tier, "2", [Editable / Non Editable]:[Editable / Non Editable], "Non editable file")
but when I try and replicate the same formula in my separate metrics sheet I'm getting a different total - 99. Does anyone have any idea where I could be going wrong here?
=COUNTIFS({06. GBT Select Inventory Active}, "Yes", {06. GBT Inventory | GBT2023-006 Tier}, "2", {06. GBT Inventory | GBT2023-006 Editable}, "Editable file")
Thanks in advance
Rosie
Answers
-
Hi Rosie,
If the formula above is what you have in sheet summary and the one below with the cross sheet reference is what you've in your separate metrics sheet, it looks like the last criteria is different between the two. Where the sheet summary is looking for "Non editable file" but the cross sheet formula is looking for "Editable file"
Thanks,
Aravind GP| Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!