I want to count percentages in a range of cells that are not contiques. I
have named the involved cells. When I use =countif(Janmon,"=85%") it returns
#Value.

For example the range would be D15:Q25 then D25:Q35. It's name is Janmon.

Why does it return #value? What is the correct formula?