Did you complete the formula with ENTER or CTRL+SHIFT+ENTER since it is an
array formula?
But why not use SUMPRODUCT ?
=SUMPRODUCT(--(C2:C500="Bell"),--(F2:F500="Yes"))
and use just ENTER to complete it
For more info see
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
http://mcgimpsey.com/excel/formulae/doubleneg.html
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Beverly C" wrote in message
...
=SUM(IF(C2:C500="Bell",IF(F2:F500="Yes",1,0)))
I have a spreadsheet that housing a list of providers and a list survey
questions. Columns F2 - F500 can be every "Yes" to "No". I tried to pick
out all the "Yes" answers for this provider and keeps getting a "1".
What am I doing wrong?
--
Beverly C.