Search results

Shame on you! ;)

In this particular example they weren't using SUMPRODUCT to conditionally sum, or at least they weren't using it to conditionally sum more than one number. It was being used to look up a company (row), GL code (row)and period (column) to return an actual value. The calc speed with the...

I've been reviewing a client's model recently - it had 27,000 cells with SUMPRODUCT, and as some of them had two SUMPRODUCTs in the formula, there were over 36,000 SUMPRODUCT calcs in the model. Needless to say the calc time was a little on the slow side, but nothing a litle OFFSET/MATCH...