Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 137
  • Last Modified:

EXCEL 2013 formula to sum on previous column

I have a spreadsheet that has columns for each day of the week, as well as WeekToDate (WTD) and YTD totals. The WTD column is calculated based on the sum of the Monday - Sunday columns.

WTD=Column I
YTD = Column J

The data in col. J here is manually entered.

Sum on WTD to calculate YTD
What I'd like to do is to have the YTD column represent the sum of the WTD from row 2 (the first data row) to the current row.

e.g. J5 would be SUM(I2:I4)
e.g. J6 would be SUM(I2:I5)


In general terms:
J<row#> would be SUM(I2:I<row#>)

Is there a (simple) formula for this calculation?

Thanks,
Steve
0
Stephen Kairys
Asked:
Stephen Kairys
  • 2
1 Solution
 
gowflowCommented:
Can you post your sample workbook ?
gowlfow
0
 
ThomasMcA2Commented:
Use the $ symbol to lock the cell references. For example, the formula =SUM(I2:I4) for J5 becomes =SUM(I3:I5) when it is copied and pasted into J6. To fix that, change your formula for J5 to =SUM($I$2:I4). The $ signs stop Excel from changing the column ($I) and row ($2) when being pasted. Once you change J5, you can copy and paste it down the J column.
0
 
Stephen KairysTechnical Writer - ConsultantAuthor Commented:
Thomas,
To confirm:

SUM($I$2:I4)

The dollar signs are before and after the first "I"? Did you mean $I2:$I4 instead?

Thanks,
Steve
0
 
Stephen KairysTechnical Writer - ConsultantAuthor Commented:
Thomas, please disregard my last comment. I tried your method and it worked! Thank you.

 Gowlfow - Thanks for wanting to help, but the workbook has some personal info in it that I could not share.
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now