See OAK elucidate a difficult formula 9 Jun 2009
What does this Excel formula do?
=IF(P1070=””,0, SUMPRODUCT(OFFSET($K1065,0,0,1,MAX(1,MIN($G1059,O$31))), OFFSET(P1070,0,0,1,MAX(1,MIN($G1059,O$31))))*O1044)
No, I haven’t a clue either. But OAK can make sense of it in moments.
[hana-flv-player video='/media/OakPruning/OakPruning.flv' /]