The objective is to use the SUMIF Function to add all transactions for, which the Supplier Name is: "AAAA" if the date of transaction is between Apr/01/2007 and Jun/30/2007
Invoice Invoice Invoice
Date Number Supplier Total
Mar/02/2007 xxx Abc $100
Mar/10/2007 xxxx AAAA $100
Mar/30/2007 xxxxxxx BBBB $100
Apr/01/2007 xxxxxx AAAA $100
May/10/2007 xxxxxx AAAA $100
Jun/15/2007 xxxx BBBB $100
Jun/20/2007 xxxx AAAA $100
Jun/30/2007 xxxxxxxx BBBB $100
Jul/01/2007 xxxxxxxx BBBB $100
I have tried so many times with no success as I used the SUMIF function in a simplified way but once I had
add one more logical condition it did not work. Can any one out there help me achieve this?
Thank you in advance!
Chamdan
Bookmarks