Hi,
I have the following calculation:
=SUMPRODUCT((AM6:AM108=1)*(K6:K108)*(I6:I108))/SUMIF(AM6:AM108,1,I6:I108)
It results in #VALUE when I generate the file, but upon opening it in Excel and F2 then enter on the cell, it has the correct values.
I am setting the above formula to the "cell.Formula" property of the cell, and I am explicitly calling Workbook.CalculateFormula() at the end.
Now I'm pretty much stuck, with my deadline ticking closer! Please can you help as soon as possible (perhaps with an alternative methodology for calculating the conditional sum product?)
Kind Regards,
Vic