automatically sum a range of cells in multiple workboks

[nickgoldie]

I am trying to find a formula or code that automatically sums all cells in different columns within different sheets. For example, i have three different worksheets with three different ranges. I want the totals calculated at the bottom of each range automatically.

[stnkynts]

Maybe i am missing something. Why dont you just use =SUM(Range)

[nickgoldie]

because i have to manually go to each sheet and sleect the range. my sheets have different ranges. i want the sum formula to know where the end of the range is and show the total there, without me selecting the range.

[stnkynts]

This should do the trick. You will have to change the column in the code to match your desired column. (example: I used column A). This will work on every worksheet in the workbook. If you need to do for multiple columns in one worksheet you would be able to repeat the code within the loop. We could get more fancy and have it do for each column that exists in a sheet or have you input a range but honestly......waste of time. Unless you got 1000 worksheets with 1000 columns just do =SUM(A$1:lastrange) and copy/paste for the other columns. Lazyness kills me sometimes.

Please Login or Register  to view this content.

Let me know.

[nickgoldie]

thanks you. it worked