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
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!