Hi, Can someone help me with using @row within my COUNTIFS formula?
The formula I'm using is: =COUNTIFS({OKS Satellite Accumulation Area Inspection Range 3}, "A-1", {OKS Satellite Accumulation Area Inspection Range 5}, "No") For some reason, when I add @row to both ranges, it comes back as unparseable
Thanks
Answers
-
@row doesn't seem to make sense here. It looks like you're using a cross-sheet reference. What your countifs should do is search an entire column (I'm assuming thats the "OKS Satellite Accumulation Area Inspection Range 3") and look for "A-1", then it searches another entire column "OKS Satellite Accumulation Area Inspection Range 5" and looks for a "No". That's what it's counting.
-
Hi Michael,
Yes, you are correct in you assumptions. Would there be a better option? I have multiple locations that are being inspected for multiple parameters
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!