check sum formula for dynamic range

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • Hi experts!

    I am trying to do the SUM function in the yellow cell, to see if the total amount (cell in blue) is correct.

    But it's a dynamic rows, eg, sometimes 5 row, sometimes 15 row, etc

    And is there any way do it in "Relative references" instead of the fixed column B, Column C, etc.

    if it is possible that when I select the yellow cell, and then run Marco to insert a Sum function that [=SUM(B2:B13,-B14)] with relative reference] in yellow cell.

    thanks :)

    Attached is the excel sheet for reference.

  • The data and blue cell was used sum function already in another excel to be print out as a financial statement. Therefore I don’t want to mess up with the original excel.

    And the purpose here is to check the figures see if everything is correct as it show

    I am copying those data from another excel and paste value here, and using this function to do the sum checking for the figures before finalize a financial report.

  • Oh yes your are right.

    But is the Marco able to do this formula ( =SUM(B2:B13,-B14) ?) or I have to do it by hand every time?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!