Hey guys, is there any way to make this formula less complicated:
=IF(C$1<=$B698+Assumptions!$C$17,IF(INT((C$1-$B698+1)/Assumptions!$C$40)=((C$1-$B698+1)/Assumptions!$C$40),SUM(C66:$C66),0),0)
It is going across 300 columns and 300 rows, and there are 2 such tables, so my file is huge.
I am not sure exactly what background to give because the file is just too huge and takes ages to open. Basically this formula is the first in the cell and I drag it across 300 columns and down 300 rows.
Bookmarks