Forum Discussion
SumProduct question
I have a complicated sumproduct equation in a cell of a spreadsheet I inherited from someone else. I wondered if anybody could possibly explain it somewhat. I know it's doing some math based on whe...
The formula sums the values in 'Outage Hours'!$E11:$AUX11 (which should be number values or blank), for which the date in 'Outage Hours'!$E$2:$AUX$2 equals the date in X$1, and the text value in 'Outage Hours'!$E$5:$AUX$5 equals "Unplanned (ROR)". This sum is divided by the value of X$2.