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
Check out the Formula Handbook template!