Help with Formula between dates

[mib1019]

Thanks in advance, as always, for help with this formula I can't figure out.

Screen shot below. I'm trying to sum the values in the range of date columns between user input at A3 and B3. Don't know if I need to get the Cell References to do and INDIRECT sum or if I can use another formula.
The yellow shading is where I'm trying to get calculations. If Columns D and E aren't needed to get Column B, I'd be happy with that!

Thanks!
Mary B

 

[mib1019]

See row 14 for the result of Sumproduct that I copied there.

 

[mib1019]

Seems that SUMIFS formula should work as well.

 

[Fluff]

You are missing a couple of brackets in the formula, that's why it's spilling.

 

[Fluff]

Because you date is in a table & the dates are the header, a sumifs will not work as the dates are text & not real dates.

 

[mib1019]

You are missing a couple of brackets in the formula, that's why it's spilling.

Where are my brackets missing?
Can I not have column headers be actual dates?

 

[Fluff]

Can I not have column headers be actual dates?

Not if you want to use a structured table.

Where are my brackets missing?

Have a look at the formula in post#3

 

[mib1019]

Not if you want to use a structured table.

Have a look at the formula in post#3

You guys a genius! I just didn't type the formula correctly. SUMPRODUCT works!

Thanks so much!
Mary B

 

[Fluff]

You're welcome & thanks for the feedback.