Sum row of numbers based on row of dates being less than today

[Mountaineer00]

I need to sum values in row B50:Y50 (integers) if the dates in row B:26:Y26 (MM/DD/YYYY) are < A25 (MM/DD/YYYY).

I'm using this to sum accrued vacation hours upto today. I have what will be accrued for the entire year per period in row 50 with the dates in row 26.

Thanks in advance!

 

[kmillen]

=SUM(--(B26:Y26 (less than sign) A25)*B50:Y50)

Enter as an array formula using Ctrl Shift Enter (CSE).

This forum won't allow me to enter a less than sign. Mmmm?

 

[Aladin Akyurek]

I need to sum values in row B50:Y50 (integers) if the dates in row B:26:Y26 (MM/DD/YYYY) are < A25 (MM/DD/YYYY).

I'm using this to sum accrued vacation hours upto today. I have what will be accrued for the entire year per period in row 50 with the dates in row 26.

Thanks in advance!

Try...

=SUMIF(B26:Y26,"<"&A25,B50:Y50)

 

[Mountaineer00]

Thanks kmillen & Aladin! Both of those worked. Many thanks!!!!

 

[Aladin Akyurek]

Thanks kmillen & Aladin! Both of those worked. Many thanks!!!!

You are welcome.