Trying to combine two functions

[Lance]

Hello,

I am trying to make an Excel File do a Year-to-Date summation on a
worksheet where the months are listed every-other column (The columns
alternate between actual and budget in the same month)

The actuals are no problem, I just sum each sell, however, the budget
is a problem, because the budget already exists, but I want to just
look at the YTD as a summary to compare with the actuals.

I have seen people post information on how to select every other cell,
and I have seen people post information on how to do a YTD formula,
however, I am at a total loss of how to combine the two. Any help would
be appreciated.

For the purpose of any sort of formulas you may post, let us assume
that the cell where teh total resides is A1, and the YTD counting
begins at A4, alternating everyother column.

Thank you very much.

 

[pape]

What you have not stated is how you identify the current month - is
that entered in another cell? Also how are your months haeded up?

Assuming you have month headings in row 4 and the data in row 5 and the
current month is entered in C2 then you would use something like this
to get your year to date total:
=SUMPRODUCT((A4:W4<(C2+1))*A5:W5*MOD(COLUMN(A4:W4),2))
I am assuming that dates in row4 and in cell C2 are the same format.
The +1 in the formula is to ensure the current month gets included too.