SumIFs greater than equal to AND less than equal to

[jrunio]

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?

 

[jrunio]

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?

 

[pgc01]

Hi
Welcome to the board

Try instead

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