Oops, didn't see that the columns were offset. Try:

=SUMPRODUCT(--(MOD(COLUMN(J10:BM10),5)=0),
--(COLUMN(J10:BM10)<=MONTH(TODAY())*5+5), J10:BM10)

In article ,
JE McGimpsey wrote:

One way:

=SUM(OFFSET(J10,0,0,1,MONTH(TODAY())))

In article ,
Sam wrote:

Hello!
I need to create a formula that will sum a series of nonadjacent cells, but
will be able to limit how many of the cells to sum based on the index. For
example, I have a dollar total based on 12 months of data:
cell: J10 O10 T10...
Mo.: Jan Feb Mar...
Amt:$100 $100 $100... and so on

However, months that are in the future have "guesstimate" data in them. I
would like to have a formula that will run on a Year-To-Date basis that
will
only sum the ACTUAL data, without having to add a cell each month to
include
that new total. (So if executed today, the formula would only sum data for
January through June, but next month, would sum January through July
without
having to change anything but the index.)

Any ideas? Thank you!