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

#### Mountaineer00

##### New Member
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.

### Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
=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?

Last edited:
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.

Try...

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

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

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

You are welcome.

Replies
1
Views
127
Replies
1
Views
380
Replies
11
Views
388
Replies
11
Views
670
Replies
6
Views
353

1,203,174
Messages
6,053,908
Members
444,694
Latest member
JacquiDaly

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back