=SUM(COUNTIF(INDIRECT({"d27:D36","F27:F36"}),"0.5 "))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"sarahz11" wrote in message
...
Hi all, thanks for your help! I have two columns of 10 cells each that
will
have percentages in them (already calculated). My results cell needs to
say
"yes" if 90% or greater of these cells (18 out of 20) show =50%, "no" if
90%
of the cells show <50%. Also, the rows of cells are not next to each
other,
they are D27:D36 and F27:F36. And sometimes F27:F36 will not have any
results
in it (it will be "N/A"). Am I trying to do too much? Thanks!!!!