Combing Multiple formulas

[anonymous321]

Hi, I have around 28 formulas that do the same job based on different conditions. I have combined them with and function. But when I use the resultant formula as formula in excel then it shows the error as shown in the screenshot. I have attached the formula and sample excel sheet as well.

My requirement is to combine them in single formula otherwise this simple task becomes a long job where I have to calculate multiple values one by one. I hope you understand my objective.

Please have a look and let me know if we can overcome this situation.


Snapshot2.PNG
Snapshot.PNG