Wrox Programmer Forums
|
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
 
Old June 30th, 2010, 08:18 PM
Registered User
 
Join Date: Mar 2010
Posts: 5
Thanks: 1
Thanked 0 Times in 0 Posts
Default 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!
 
Old July 1st, 2010, 02:42 AM
Friend of Wrox
 
Join Date: Sep 2005
Posts: 812
Thanks: 1
Thanked 53 Times in 49 Posts
Default

Hi

Can you try =SUM(B2:CK2)

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

VBA Tips & Tricks (http://www.vbadud.blogspot.com)
The Following User Says Thank You to Shasur For This Useful Post:
ferretti40 (July 1st, 2010)
 
Old July 1st, 2010, 01:06 PM
Registered User
 
Join Date: Mar 2010
Posts: 5
Thanks: 1
Thanked 0 Times in 0 Posts
Default

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





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.