Hi there, I have a spreadsheet with multiple cells containing a list of values "Yes" and "No". To start, I would like to have a formula that calculates a value of 3 if ANY 1 of the cells contains "Yes", otherwise return 1.

Ultimately, I would also like to SUM the results into 1 cell. NOTE: The value for "Yes" in 1 cell may differ from another cell. (i.e. if A1 contains text "Yes" then result is 4 ADDED TO if B1 OR C1 contains text "Yes" result is 3 else 1).

I am trying nested IF statements with ISNUMBER(SEARCH) and also combine with OR, but cannot seem to get the right syntax?

Any assistance would be appreciated.

Mike