Calculate YTD except "this" month across multiple tabs.

[crabbyboy]

Hello,

I was hoping someone could help with this challenge (at least for me!):
I am trying to run YTD counts for "all months prior to this one". For example, in February I only want to count January; in March I only want to count Jan and Feb and so forth.
Each month is in its own sheet/tab. The YTD sheet/tab is also on its own and where the formula should go.

I've tried using SUM, SUMIF, SUMIFS, SUMPRODUCT, INDIRECT and a couple of others with no such luck.

A simple SUMIF formula would work if all the data is in the same tab, one for ea employee and with columns representing the months .

=SUMIF(A1:L1,"<="&N1,A2:L2)

For example, the formula above works where:
A1:L1 is a range of months from Jan to Dec.
N1: is a cell containing this month.
A2:L2 is a range of values to sum.

When I tried to reproduced the above across the multiple tabs, I tried this:
=SUMIF('January 2013:December 2013'!B1,"<"&A1, 'January 2013:December 2013'!C2) where:
'January 2013:December 2013'!B1: is the "range" across the sheets where B1 holds the month name.
"<"&A1: A1 holds this month name in the YTD sheet.
'January 2013:December 2013'!C2: is the "range" across the sheets where C1 hold the values to add if the condition is met.

At any rate. Anything you can provide will be really helpful!

Thank you!
m@rcelo
[TABLE="class: grid, width: 260"]
<tbody>[TR]
[TD]Jan-13[/TD]
[TD="align: right"]Jane [/TD]
[TD="align: right"]Paul[/TD]
[TD="align: right"]Chris[/TD]
[/TR]
[TR]
[TD]Projected Amount[/TD]
[TD="align: right"]10,000[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]43000[/TD]
[/TR]
[TR]
[TD]Actual Amount[/TD]
[TD="align: right"]13000[/TD]
[TD="align: right"]1,200[/TD]
[TD="align: right"]75,000[/TD]
[/TR]
[TR]
[TD]Difference [/TD]
[TD="align: right"]3,000[/TD]
[TD="align: right"]-3,800[/TD]
[TD="align: right"]32,000[/TD]
[/TR]
</tbody><colgroup><col><col><col><col></colgroup>[/TABLE]
[TABLE="class: grid, width: 260"]
<tbody>[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]Feb-13[/TD]
[TD="align: right"]Jane [/TD]
[TD="align: right"]Paul[/TD]
[TD="align: right"]Chris[/TD]
[/TR]
[TR]
[TD]Projected Amount[/TD]
[TD="align: right"]20,000[/TD]
[TD="align: right"]6,000[/TD]
[TD="align: right"]45,000[/TD]
[/TR]
[TR]
[TD]Actual Amount[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]Difference [/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody><colgroup><col><col><col><col></colgroup>[/TABLE]
[TABLE="class: grid, width: 260"]
<tbody>[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]YTD-13[/TD]
[TD="align: right"]Jane [/TD]
[TD="align: right"]Paul[/TD]
[TD="align: right"]Chris[/TD]
[/TR]
[TR]
[TD]Projected Amount[/TD]
[TD="align: right"]10,000[/TD]
[TD="align: right"]5,000[/TD]
[TD="align: right"]45,000[/TD]
[/TR]
[TR]
[TD]Actual Amount[/TD]
[TD="align: right"]13,000[/TD]
[TD="align: right"]1,200[/TD]
[TD="align: right"]75,000[/TD]
[/TR]
[TR]
[TD]Difference [/TD]
[TD="align: right"]3,000[/TD]
[TD="align: right"]-3,800[/TD]
[TD="align: right"]32,000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody><colgroup><col><col><col><col></colgroup>[/TABLE]

 

[jfcassie]

Hello,

I was hoping someone could help with this challenge (at least for me!):
I am trying to run YTD counts for "all months prior to this one". For example, in February I only want to count January; in March I only want to count Jan and Feb and so forth.
Each month is in its own sheet/tab. The YTD sheet/tab is also on its own and where the formula should go.
[TABLE="class: grid, width: 260"]
<tbody>[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]

Crabbyboy, did you ever solve this?