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 whether certain group of cells includes the words "Unplanned (ROR)" but I can't quite follow it.
=IF(TODAY()>=X$1,(SUMPRODUCT(--('Outage Hours'!$E$2:$AUX$2=X$1),--('Outage Hours'!$E$5:$AUX$5="Unplanned (ROR)"),'Outage Hours'!$E11:$AUX11)/X$2),"")
1 Reply
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.
