How can I write a formula that will sum the value from multiple columns using an index match matrix based approach?
The formula below will work when there is only one column that has the "OC_TECH" value, but I want to sum both values if "OC_TECH" occurs as a column header more than once.
for...