Hi, Can someone help me with using @row within my COUNTIFS formula?

DonC33

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

Michael Culley

@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.

DonC33

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