Summing values in a row depending on certain conditions being met.

Have a table that will contain 28 columns of data. Each column will have an “Alpha” and a “Numeric” value at the top of it.

Need to calculate various sums on each row depending on the “Alpha” and or “Numeric” value.

Firstly sum all the values in row 5 that have a corresponding “Numeric” value of 1. The “Alpha” and or “Numeric” values will not necessarily be in any sequential order.

Next when the “Numeric” value is 1 or 2 I need to sum the maximum values for each “Alpha”

Finally sum the two highest values for each “Alpha”

Hope the attached example makes what I want clearer.

Thanks

see the attached file