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.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!