COUNTIF Using Open-Ended Range Formula (Not Working)
I'm using the COUNTIF formula and am trying to set an open-ended range formula (see below). When I do so, I receive the error #UNPARSEABLE
=COUNTIF(Test Result:Test Result, Status1)
Is there any reason this wouldn't work?
I've attached a screenshot of how Test Result is defined.
Help Article Resources
Check out the Formula Handbook template!