Help developing a formula

[mikecox39]

Can someone help me with a formula to sum integer values stored in cells in a single row, based on the current date.


In row 1, starting in column B, there are 12 cells containing dates April through March. B1:M1


In row 26, starting in column B, there are 12 cells that contain integer values. B26:M26


i would like to add all the integer values in row 26, starting with B26 up to and including the cell with the current date.


Based on the current month of July that would be the integers in B26:E26 based on the date in E1.


I would put the formula at the end of the integers in row 26, at N26.

 

[dreid1011]

Can someone help me with a formula to sum integer values stored in cells in a single row, based on the current date.


In row 1, starting in column B, there are 12 cells containing dates April through March. B1:M1


In row 26, starting in column B, there are 12 cells that contain integer values. B26:M26


i would like to add all the integer values in row 26, starting with B26 up to and including the cell with the current date.


Based on the current month of July that would be the integers in B26:E26 based on the date in E1.


I would put the formula at the end of the integers in row 26, at N26.

What do the date values look like?

 

[JoeMo]

Assuming your dates are numbers not text, try:

=SUMIF(B1:M1,"<="&TODAY(),B26:M26)

 

[mikecox39]

The dates in row 1 are formatted 4/1/2017 through 3/1/2018

 

[mikecox39]

Perfect! Thanks so much!!

 

[JoeMo]

Perfect! Thanks so much!!

You are welcome - thanks for the reply.

 

[mikecox39]

I was able to put your formula to work for all the rows in my spreadsheet! I just had to Edit the B1:M1 range after I dragged it down the column because doing so changed the row number. I just went in and changed that range back to B1:M1. It's working perfectly now!

Thanks again! I've studied the formula and have learned things that will help in the future!