Count the opening & closing parentheses. They need to match.
I think that Bernard intended to say:
=SUMPRODUCT(--ISTEXT(A1:A100), --(B1:B100=69%), --(B1:B100<=81%))
--
David Biddulph
"angiec50" wrote in message
...
Dear Bernard. Yes your rephrase is correct however, I have typed in the
formula exactly as you have written it but when I press Enter is states
that
there is an error, but wont tell me what part is errored. I have had a
look
at the link you attached about SumProduct, however, that has completly
confused me. I am using Excel 2000 could this be the reason it doesnt
work
Regards
Angie
"Bernard Liengme" wrote:
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