Sum(if not working
=SUMPRODUCT(--(C2:C500="Bell"),--(F2:F500="Yes"))
This will return the count of records for which C2:C500 = "Bell" AND F2:F500
= "Yes" which is what I think you're trying to do.
Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.
"Beverly C" wrote:
=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.
|