Hello,
Was trying to optimize a sumproduct formula that uses date comparison conditions. The following formula works fine:
=SUMPRODUCT(SUMIFS(PerAct,Entity,--(INDIRECT("EntLst")),Date,INDIRECT("D1"),Date, INDIRECT("D2"),Account,--(INDIRECT($A4))))
D1 is a cell with a date formatted as...