LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Jim
 
Posts: n/a
Default sum and variable rows

I give up. Each month I have to sum up a series of rows. I have a worksheet
with all of the data called Raw Data.

Then I have a totals worksheet that has stuff like:

In totals, A1 I have =SUM('Raw Data'!C1959:C2329)
In totals, A2 I have =SUM('Raw Data'!N1959:N2329)

What I would like to do is place the start and stop row numbers in totals!X1
(1959), totals!Y1 (2329) so I don't have to manually enter these ranges each
month. I have not been able to figure out the correct syntax for changing
A1 and A2 to get the row number from a cell. I thought it would be something
like:

=SUM(INDIRECT("'Raw Data'!C"&totals!X1):INDIRECT("'Raw Data'!C&totals!Y1))
but I'm wrong. Question is, am I even in the right ball park. Thanks in
advance.
 
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



All times are GMT +1. The time now is 11:53 AM.

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

About Us

"It's about Microsoft Excel"