COUNTIF Using Open-Ended Range Formula (Not Working)

mrsmorden

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.

 

Brian W

If your column has spaces in the name, you need to add brackets in the formula. Try this:

=COUNTIF([Test Result]:[Test Result], Status1)

mrsmorden

That was the problem. Thanks!!!