I'm working with nested IF formulas, and cannot figure out how to sum the end values with other nested IF end values. For example,..


Where cell A1 contains the word "Yes", B1 is assigned the value 0.
Where cell A1 contains the word "Unknown", B1 is assigned the value 1.
Where cell A1 contains the word "No", B1 is assigned the value 2.

Where cell C1 contains the word "Yes", D1 is assigned the value 0.
Where cell C1 contains the word "Unknown", D1 is assigned the value 1.
Where cell C1 contains the word "No", D1 is assigned the value 2.

I need to sum the total of B1 and D1. Since these are the results of formula's, and not just entered numbers, the SUM function does not recognize them as numbers. I'd prefer not to paste values as my values for A1 and C1 will change over time.

Any ideas on how I can calculate the Sum of two values when the values are the product of formulas (namely a Nested IF formula)?