5 Criterias in 1 Formula

[vill]

Hi guys,

Don't know if its even fair to be asking help on this one, as its a formula to possibly challenge even strongest Excel expert... Surely not something I can crack up on my own... in any case, giving it a try, but would perfectly understand if this one is beyond our limits.

In a nutshell, there is a need to come up with ONE single formula for 5 different criteria (which are basically 5 different formulas to fit in 1) If possible, without helper columns/rows, arrays, macros etc.

Additional details are that this formula is to be used as a part of 0 to 10 rating system, where one final number (0 to 10) needs to return average based on 5 different criterias. Again, if possible, without additional columns/rows etc (file already contains lots of data, so if any additional stuff could be avoided, that would be best)

There is no need to try changing how sheets, or data etc are structured (can't change it in original copies anyway), but literally all is required is to just write a single formula which will have all 5 criterias/formulas blended in it.

Attaching actual Excel file with full details, and a screenshot below.

If possible to take a look, any feedback, questions or suggestions are welcome. Thanking (lots) in advance.

https://www.excelforum.com/attachmen...1&d=1509199831 [EXCEL]

2017-10-28_1655.png