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).

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]record 1[/TD]
[TD]12.1.15[/TD]
[TD]12.2.15[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]record 2[/TD]
[TD]12.1.15[/TD]
[TD]12.3.15[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]record 3[/TD]
[TD]12.2.15[/TD]
[TD]12.3.15[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]


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

My return should look like this:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]12.1.15[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]12.2.15[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]12.3.15[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]



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)