Using SumProduct for multiple triggers

[szm187]

This is an extension of my original question here...
http://www.excelforum.com/excel-gene...html?p=2734526

(In case you wanted a copy of the spreadsheet attached)

Basic premise:

I am using Sheet1, it has 2 columns. One with a date, one with a dollar amount.
On Sheet2, I have a SumProduct calc stating:
=SUMPRODUCT(('Sheet1'!A1:A999=D13)*('Anticipated Cash'!B1:B999))
(D13 is in reference to a specific date.

I'm working on this spreadsheet some more, and would like a seperate calculation to not only include the specific date, but also (let's say in column F) I would like to put a word (We'll say "Confirmed") so that it only calculates the dollar amounts of those that match the date AND if it has confirmed in column F.

So, I would like it basically to calculate what was accepted in the first calculation, and then filter it based on whether or not Confirmed is present in column F. If anything else is written, then it wouldn't be added in. I'm not married to the idea of it being SumProduct, it could be anything really, but I'm just wondering the most plausible method to make this work. Thanks for any help you can offer.