Help with SUMProduct with two date ranges

[Muttstaz]

How do I use SUMPRODUCT to sum a column using dates from another column? For example, I need to sum all the amounts that are due in February. My due dates range all of February not just the word "February". I have tried to do it using
SUMProduct(--(F6:F11,"<2011-01-31")*(F6:F11," >2011-03-01"),E6:E11)
It comes back zero. What am I doing wrong?

[NBVC]

Try:

=SUMIF(F6:F11,">2011-01-31",E6:E11)-COUNTIF(F6:F11,">=2011-03-01",E6:E11)

or

=SUMPRODUCT(--(F6:F11<"2011-01-31"+0),--(F6:F11>"2011-03-01"+0),E6:E11)

[arthurbr]

Hi and welcome to the board

Maybe =SUMProduct((F6:F11>date(2011,1,31))*(F6:F11<date(2011,3,1))*(E6:E11))

You can also enter the dates in cells and refer to them in your formula

This is assuming you have real dates, not text looking like dates

[Muttstaz]

Arthurbr
Thanks so much for the welcome!

And, thanks so much for the help!! Worked like a charm!!