Help with Sumifs formula involving dates

[jeffreyp]

I have two tabs in an Excel worksheet, one named "GL". That tab is a SQL feed from our GP Dynamics ERP that returns three columns:
Column A: Account
Column B: Date (Formatted in Date *3/14/2012 format)
Column C: Amount.

On the other tab where I am trying to bring in data from the GL tab, I have Begin Week dates in row 2 and End Week dates in row 3. Those dates are also Formatted in Date *3/14/2012 format
I am trying to create a formulas to bring in all amounts in the date range of 12/6/2014-12/12/2014 for account 10-30000. If I don't include dates in the formula I get the correct total for account 10-30000 for the entirety of my data set. It's when I start trying to use the dates in row 2 and row 3 that my formula returns 0 I am trying to put a formula on the Flash Report tab cell B9 that would sum up the total of GL account 10-3000 between the dates in cells B2 and B3. See Screenshots. I've googled multiple pages for help, some say I need to format the dates in a certain way and some don't. Can anyone help?

 

[Joe4]

I believe this article shows you how to do what you are looking for: Excel SUMIFS date range formula - sum if between two dates

 

[Alex Blakenburg]

The article Joe referred you to will have this but in summary, you have your cell reference inside the quotes which makes it just a text string instead of a cell reference. Try changing:
">=B2" to ">=" & B2
"<=B3" to "<=" & B3