Multiple SumProduct Functions

N

N/A

I have a list of monthly charges and am populating it with information from a
table based on dates and use the following to do so:
=SUMPRODUCT(--(Sheet2!$C$3:$C$999>DATE(2004,11,15)),--(Sheet2!$C$3:$C$999<=DATE(2004,12,15)),Sheet2!$F$3:$F$999).
However, now I want to take and other table where the same date criteria
would apply and want to add it to the results of the function listed (this
table would also rely on a date criteria). I am assuming it would be a
nested argument I just can't figure out how to write it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Require formula to search across multiple worksheets 2
Sumproduct giving #Value error 5
Sumproduct Help! 3
SUMPRODUCT help needed 7
another sumproduct with #value error... 5
Multiple variables to sort and sum, return values<0 with sum refer 5
Function or Sub to help with text string 5
Conditional Formatting from a group 6

Top