sum range variable

  1. T

    Changing SUM Range using formula

    Hi all, Novice here Am currently using SUM to sum a group of numbers in cells below the Result Cell. This is shown in pic 1 and 2. I have sections divided by the yellow strip, each section having varying amounts of lines to SUM. After entering the SUM for the first section, I would copy and...
  2. J

    vba sum range

    LastRow2 = Range("A50000").End(xlUp).Row Range("A40").End(xlDown).Offset(0, 11).Value = "=Sum("M23:M" & "LawRow2")" I am trying to sum M23 to last row of M but it is not working correctly. Is there any way to fix this code to work? Thanks!
  3. P

    Need macro for variable sum range

    I have a value in cell B6 that represents a count of the number of weeks in a range. this value can change depending on how many weeks the project runs for. I need to write a macro that will create a sum, using the value in B6 + 4 as the ending column. The starting column will always be...
  4. A

    Help! Sum Variable Range in closed workbook

    Ladies and Gents, I need some help figuring out how I can sum a range of cells closed workbooks based on information inputted in an open book. Essentially I am looking up data in tables in the closed workbooks, the data can be index/matched fairly easily however I am needing to sum 50 or...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top