Summing $ Amounts, using a date range, and key words in other columns as restrictions

Here we go... I'm going to try and explain this the best I can.

I have 3 different columns: A, B, C

A= Date

B= Reviewed

C= $ amount

I would like to find out how to add the total $ amounts in column C, when they fall between monthly date ranges, located in column A, and have the word reviewed in column B.

Better said, "I need to know the total $ amount of reports reviewed between January 1st - January 31st."

Any ideas or suggestions? Thank you

=Sumproduct(--($A$2:$A$100>="January 1, 2008"+0),--($A$2:$A$100<="January 31, 2008"+0),--($B$2:$B$100="Reviewed"),$C$2:C$C100)

adjust ranges to suit... you can replace dates with cell references...

You list this range 'Requests Received'!$D$2:$D$12000 twice in your formula. Does that range contain text and numbers?

You have one misplaced set of parenthesis...

Try:

=SUMPRODUCT(('Requests Received'!$A$2:$A$12000>=DATE(2008,7,1))*('Requests Received'!$F$2:$F$12000<=DATE(2008,7,31))*('Requests Received'!$I$2:$I$12000="Closed")*('Requests Received'!$D$2:$D$12000))

If that doesn't work still, then check that you don't have text in column D and that none of the ranges have errors in them.