Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 9th 08, 12:49 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2008
Posts: 8
Default Sum below a specific row

I am attempting to use the SUM function to add values below a certain row? I
know that SUM(A:A) can be used to add every value in the column, and
SUM(A1:A5) can be used to add values in a defined range.

What do I do if I only know one of the values in my range? For example, I'd
like to be able to add the values in column A for every row below row 8
without having to change the defined range each time. e.g - SUM(A9:A??)

How can this be accomplished?

  #2   Report Post  
Old July 9th 08, 01:57 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 72
Default Sum below a specific row

Hi jdunnisher,

You can sum all numbers below row 8,

SUM(A9:A1048576)

because Excel 2007 has a 1,048,576 row capacity,

or

If all of the cells between the first cell and the last cell have a value,
and there is always a blank after the last cell to be summed:

=SUM(INDIRECT("A9:A"&MATCH(99999999999999999999999 9999999,A:A,1)))

In place of the 999..., use a number that will always be greater than any
number being summed.

Thanks,
Peggy


"jdunnisher" wrote:

I am attempting to use the SUM function to add values below a certain row? I
know that SUM(A:A) can be used to add every value in the column, and
SUM(A1:A5) can be used to add values in a defined range.

What do I do if I only know one of the values in my range? For example, I'd
like to be able to add the values in column A for every row below row 8
without having to change the defined range each time. e.g - SUM(A9:A??)

How can this be accomplished?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Not allowing to continu unless a specific cell has specific answer madubois9 Excel Discussion (Misc queries) 3 October 25th 07 12:45 AM
Link to specific cell in specific Excel file JeroenM Excel Discussion (Misc queries) 3 July 6th 07 10:08 AM
Link from a specific Cell in Excel to a specific para. in Word CathyK Excel Worksheet Functions 0 August 10th 06 04:40 PM
Highlight a row if a specific cell is specific numbers/words sea0221 Excel Worksheet Functions 2 March 9th 05 01:06 AM
How do I make a cell date specific to input a value on a specific. ebuzz13 Excel Discussion (Misc queries) 1 January 18th 05 06:53 PM


All times are GMT +1. The time now is 11:13 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017