Microsoft Office Forums From a particular cell till the end of the same column

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-09-2011, 08:39 AM
tinfanide tinfanide is offline From a particular cell till the end of the same column Windows XP From a particular cell till the end of the same column Office 2010 32bit
Expert
From a particular cell till the end of the same column
 
Join Date: Aug 2011
Posts: 308
tinfanide is on a distinguished road
Default From a particular cell till the end of the same column

What I want is:

Sum formula in A1
Sum all the values from A2 to A* (till the end of the column A)


because I will add data to the column A later on, I cannot specify A2:A?

How can I possibly do it in Excel?
Reply With Quote
  #2  
Old 08-09-2011, 09:30 AM
OTPM OTPM is offline From a particular cell till the end of the same column Windows 7 32bit From a particular cell till the end of the same column Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
Here is the solution:
=SUM(A2:A1000001)
This formula will sum one million entries
Whenever you add values to the column, if you have automatic calculation turned on, the formula will recalculate. If not then press F9 to calculate manually.
Good luck.
Tony(OTPM)
Reply With Quote
  #3  
Old 08-09-2011, 03:39 PM
Colin Legg's Avatar
Colin Legg Colin Legg is offline From a particular cell till the end of the same column Windows 7 32bit From a particular cell till the end of the same column Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

If you use the table feature available in Excel 2010 then your SUM formula can reference the table column, and the table column will automatically expand as you add data to the table.
Reply With Quote
  #4  
Old 08-10-2011, 05:09 AM
tinfanide tinfanide is offline From a particular cell till the end of the same column Windows XP From a particular cell till the end of the same column Office 2010 32bit
Expert
From a particular cell till the end of the same column
 
Join Date: Aug 2011
Posts: 308
tinfanide is on a distinguished road
Default

Thanks for both replies.

Yes, I can use the table feature in 2010.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why the "Text boundaries" are not shown till the end of the page while in other file Jamal NUMAN Word 4 03-28-2012 07:58 AM
How can I delete the content of a cell in column if the cell value is more than 1000? Learner7 Excel 2 06-27-2011 05:44 AM
From a particular cell till the end of the same column Need to search a column for a macth and return a result from a third column pdfaust Excel 2 02-03-2011 03:02 PM
Auto-populate an MS Word table cell with text from a diff cell? dreamrthts Word Tables 0 03-20-2009 01:49 PM
How do I reference a merged cell in a multi column & row table in MS Word ('03')? jihanemo Word Tables 0 03-18-2009 08:33 AM


All times are GMT -7. The time now is 01:14 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft