Sum an unknown range

Felafel

New Member
Joined
Sep 2, 2002
Messages
11
want to know how to sum an unknown range, say for example i wanted to sum all the values in a column from cell 15 down to the bottom, but i don't want the value to be entered in that column, say it's going to be stored in ColA when the date is in ColB.

How do i go about this?
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
On 2002-09-03 18:43, Felafel wrote:
want to know how to sum an unknown range, say for example i wanted to sum all the values in a column from cell 15 down to the bottom, but i don't want the value to be entered in that column, say it's going to be stored in ColA when the date is in ColB.

How do i go about this?

Hi - welcome to the board!

It's not that hard to perform calculations on changing ranges of cells. But you've really lost me with the "i don't want the value to be entered in that column, say it's going to be stored in ColA when the date is in ColB" bit :) How about posting a worked through example stating what your data is & the results you'd expect. You could consider downloading the html maker addin fro the link below this post & posting a snapshot of your data to the board.

Paddy
 

Forum statistics

Threads
1,144,733
Messages
5,725,981
Members
422,652
Latest member
Elnene1

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
Top