CODEWITHSUNDEEP
excelexcel-formula
Gary_P
Gary_P

Reputation: 1

Sum of an array in row that says "Yes"

=SUM(3, IF(B8:B129="Yes",1,0))

The formula should start on 3 and add 1 every time a column in the row says "Yes", Included in the row are "No" and "Maybe".

The current formula above provides the correct result however it outputs "#!VALUE" in the column.

Anybody know the issue with the formula?

Thanks in advance

Upvotes: 0

Views: 558

Answers (1)

Anonymous
Anonymous

Reputation: 51

Instead of IF(B8:B129="Yes",1,0) you may want to use COUNTIF(B8:B129,”Yes”)

Upvotes: 1

Related Questions