Using countif with a name of a range
I don't think you can do it with the name, it always seems to return #VALUE
no matter what I try, but you can with the ranges
=SUM(COUNTIF(INDIRECT({"D15:Q25","D25:Q35"}),"=85% "))
you do realise however that if there is a value in row 25 for =85%, it will
count twice?
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
"webster" wrote in message
...
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?
|