=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.