Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hi - You should be able to treat the case of your formula B147 replacing your formula by:

=INDIRECT("B"&ROW()-1)+C147

With this formula the sum is always done by adding the cell above with the right