Can I rephrase this to: you want to count how many cells in column A have
text when the corresponding cell in column B is in the range 69% to 81% ?
=SUMPRODUCT(--(ISTEXT(A1:A100), --(B1:B100=69%), --(B1:B100<=81%) )
Change the ranges (A1:A100) as needed. Unless you are using XL 2007 do not
use full column references (A:A).
For more details on SUMPRODUCT
Bob Phillips
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
J.E McGimpsey
http://mcgimpsey.com/excel/formulae/doubleneg.html
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"angiec50" wrote in message
...
I want to count cells with text in one column that matches the criteria if
the cell show anything from 69% to 81%.
So far I have tried sumproduct, countif, sumif, I am nearly there but not
quite.
Can anyone help