year to date calculation

[Jeff C]

Hi all,

I simply want to add up monthly totals of budget figures starting from the beginning of the year up to the current month. My data looks like this:

April -04 May June July Aug Sept Oct Nov Dec Jan-05 Feb YTD
10 20 30 40 50 60 70 80 90 90 90

So, if the current month was June, I'd have 10+20+30.

What is the formula to accomplish this? Thanks in advance,

Jeff

 

[Bob Phillips]

Jeff,

Assuming the amounts are in A2:L2, then

=SUM(INDIRECT("A2:"&CHOOSE(MONTH(TODAY()),"J","K","L","A","B","C","D","E","F
","G","H","I")&"2"))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Hi all,

I simply want to add up monthly totals of budget figures starting from the

beginning of the year up to the current month. My data looks like this:

 

[Charlie]

Jeff,

One way would be =SUMIF(4:4,">0",4:4) with 4 being the row
the monthly amounts are in.

Charlie O'Neill

-----Original Message-----
Hi all,

I simply want to add up monthly totals of budget figures

starting from the beginning of the year up to the current
month. My data looks like this:

 

[Frank Kabel]

Hi
if your values in row 1 are real date values (just formated as MMM-YY)
then you could use a formula like
=SUMIF(1:1,"<" & DATE(YEAR(TODAY()),MONTH(TODAY())+1,1),2:2)

if your values in column A are not real date values use Bob's solution

 

[Wheely]

I would use the offset function ie

You have the following data:

Column A B C D
Row 1 Month Number 2
Row 2 Jan Feb Mar YTD
Row 3 15 6 12

If you wanted to sum the YTD totals upto the end of Feb ie month 2 the following formula needs to be entered into cell D3

Sum(Offset(a3,0,0,1,$B$1)) this will return the answer 21.

Hope this helps