Hi!
I need to create a order report that counts all number of orders, based on a date match, and a order code match, that may appear multiple times in a separate financial report.
So, sum is based on if both of the following instances occur:
Code "PLL" appears in Sheet2 range A2:A1000
Date in Sheet1 cell D5 appears in Sheet2 range E2:E2000
If yes to both, need to add qualified values of Sheet2 range C2:C2000
I'm not that Excel savvy, so any help would be much appreciated!
Thanks!
I need to create a order report that counts all number of orders, based on a date match, and a order code match, that may appear multiple times in a separate financial report.
So, sum is based on if both of the following instances occur:
Code "PLL" appears in Sheet2 range A2:A1000
Date in Sheet1 cell D5 appears in Sheet2 range E2:E2000
If yes to both, need to add qualified values of Sheet2 range C2:C2000
I'm not that Excel savvy, so any help would be much appreciated!
Thanks!