Hi all. My knowledge of Excel is basic to intermediate, and I'm trying to find a solution to my spreadsheet. Any assistance would be appreciated. On the second worksheet, I need to search columns A(calendar month range),E, then sum F. I would like this sum to transfer over to the first spreadsheet. I've tried a productsum formula, but it is only picking up the 1st day of the month, not the whole calendar month. Thanks.