conditional aggregation

I need help to work out the formula I need for my project.

I have two worksheets. See attached.

On Nikkis Working worksheet I have recorded all my data. In columns M&N I have the dates and amounts of deposits paid. In columns T&U I have the dates and amounts of invoices paid.

I am currently using the following formula to work out how many quotes and invoices are processed each month. This is for the quotes accepted in Dec 2010.
=SUMPRODUCT(--(MONTH('Nikkis Working'!M2:M1142)=MONTH(A20)),--(YEAR('Nikkis Working'!M2:M1142)=YEAR(A20)),--('Nikkis Working'!B2:B1142="Accepted"))

I need to find the formula to have the amounts for the Deposits Paid for the Month and Invoices Paid for the month. Thank you in advance.

Nikkis Working.JPG
Nikki Critical data.jpg

If you're using XL2007 as implied you should be using COUNTIFS & SUMIFS rather than SUMPRODUCT (unless backward compatibility is required) as they are significantly more efficient.

Your above SUMPRODUCT would be re-written as:

Please Login or Register  to view this content.

In terms of subsequent calculations:

Please Login or Register  to view this content.

both assume Accepted in B range remains a requirement - remove if not.

Alternative to all of the above: use a Pivot Table


On a final note - better to post files than images - they need not be your "real" files (confidential) just a file that reflects your set up etc...

Thank you for your help. Thats great.