SumIf today's date falls between 2 dates

[kcrabb2]

I'm trying to sumif today's date falls between dates in two different columns, below is an example of how the data may look.

[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]Capitalization Date[/TD]
[TD]Retirement Date[/TD]
[TD]Value[/TD]
[/TR]
[TR]
[TD]01/01/2015[/TD]
[TD]12/31/2020[/TD]
[TD]150,000[/TD]
[/TR]
[TR]
[TD]01/01/2014[/TD]
[TD]12/31/2019[/TD]
[TD]100,000[/TD]
[/TR]
[TR]
[TD]06/01/2016[/TD]
[TD]12/31/2021[/TD]
[TD]50,000[/TD]
[/TR]
</tbody>[/TABLE]


So the returned value in this example would be 250,000. Seems like ti should be simple, I'm just struggling today....Thanks in advance!

 

[Joe4]

Try SUMIFS (if you have Excel 2007 or newer):

=SUMIFS(C2:C4,A2:A4,"<=" & TODAY(),B2:B4,">=" & TODAY())

 

[kcrabb2]

Worked perfectly. Thank You!