# SumIFs greater than equal to AND less than equal to

#### jrunio

##### New Member
I have records with a starting date (A:A) and ending date (B:B) and a quantity (D:D). I have Chronological dates (H:H) I am looking for the sum of data in D if the corresponding A Date is less >= today AND corresponding B Date is <= today.

I have written: SUMIFS(D:D,\$H1,">=A:A",\$H1,"<=B:B")

Needless to say, its not working. Thoughts?

### Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

#### jrunio

##### New Member
Better explanation:

I have record numbers in A:A, starting date (B:B) and ending date (C:C) and a quantity (D:D).

 record 1 12.1.15 12.2.15 1 record 2 12.1.15 12.3.15 1 record 3 12.2.15 12.3.15 1

<tbody>
</tbody>

I am looking for a sum of D for records whos start date is >= Today and <= Today

My return should look like this:
 12.1.15 2 12.2.15 3 12.3.15 2

<tbody>
</tbody>

I have written: SUMIFS(D:D,\$H1,">=B:B",\$H1,"<=C:C")

Needless to say, its not working. Thoughts?

Last edited:

#### pgc01

##### MrExcel MVP
Hi
Welcome to the board

=SUMIFS(D:D;B:B;"<="&H1;C:C;">="&H1)

Replies
3
Views
245
Replies
5
Views
410
Replies
0
Views
131
Replies
3
Views
77
Replies
6
Views
841

1,171,700
Messages
5,877,014
Members
433,228
Latest member
Sarah1989

### 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