Wrox Programmer Forums YTD by day
 |
 Excel VBA Discuss using VBA for Excel programming.
 Welcome to the p2p.wrox.com Forums. You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

June 30th, 2010, 08:18 PM
 ferretti40 Registered User Join Date: Mar 2010 Posts: 5 Thanks: 1 Thanked 0 Times in 0 Posts
YTD by day

I need a way to see YTD on a daily basis as we load data daily. For example in row 1 I have dates: A1 = 01/01/2010, B1 = 01/02/2010, C1=01/03/2010
in row 2 I have values: A2 = 100 B2= 125 C2=110
in row 3 have YTD: A3=100 B3= 225 C3=335

How do I do this in the cells in Row three without having to do what I'm doing now: B3= A2+B2, C3=A2+B2+C2 etc...

Currently I'm looking at data across three months (90 days) and the formula in my last cell in row 3 looks like this (=A2+B2+C2+D2+E2+F2+G2+H2+I2+J2+K2+L2+M2+N2+O2+P2+ Q2+R2+S2+T2+U2+V2+W2+X2+Y2+Z2+AA2+AB2+AC2+AD2+AE2+ AF2+AG2+AH2+AI2+AJ2+AK2+AL2+AM2+AN2+AO2+AP2+AQ2+AR 2+AS2+AT2+AU2+AV2+AW2+AX2+AY2+AZ2+BA2+BB2+BC2+BD2+ BE2+BF2+BG2+BH2+BI2+BJ2+BK2+BL2+BM2+BN2+BO2+BP2+BQ 2+BR2+BS2+BT2+BU2+BV2+BW2+BX2+BY2+BZ2+CA2+CB2+CC2+ CD2+CE2+CF2+CG2+CH2+CI2+CJ2+CL2+CK2) HELLLLLPPPP!

July 1st, 2010, 02:42 AM
 Shasur Friend of Wrox Join Date: Sep 2005 Posts: 812 Thanks: 1 Thanked 53 Times in 49 Posts

Hi

Can you try =SUM(B2:CK2)

Cheers
Shasur
__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

 The Following User Says Thank You to Shasur For This Useful Post: ferretti40 (July 1st, 2010)

July 1st, 2010, 01:06 PM
 ferretti40 Registered User Join Date: Mar 2010 Posts: 5 Thanks: 1 Thanked 0 Times in 0 Posts

Thanks Shasur! I made the 1st cell a constant =SUM(\$B\$2:CK2)and dragged it across and it worked! So simple-- I feel silly!

 Similar Threads Thread Thread Starter Forum Replies Last Post getting the same day of the week. crabjoe Classic ASP Basics 3 February 27th, 2008 12:45 PM DAY of the week wdepreter Excel VBA 3 February 7th, 2007 06:44 AM how to get the day from a given date pherms Classic ASP Basics 2 April 16th, 2004 05:38 PM day to day use of XML mano XML 1 November 27th, 2003 01:39 AM