Forum Discussion
Solved
Allocations in excel
Hi, Looking for some assistance in what I can describe as 'cell allocations' in excel. Basically want to perform a simple calculation, but once a cell has been used to calculate, move onto the nex...
=IFERROR(C8/SUM(INDEX(A:A,7+SUM($D$7:D7)):INDEX(A:A,6+SUM($D$7:D8))),"")You can try this formula.
=IFERROR(C8/SUM(INDEX(A:A,7+SUM($D$7:D7)):INDEX(A:A,6+SUM($D$7:D8))),"")You can try this formula.