I need a formula that will automatically add an amount to a total in a
different workbook if the amount meets two criteria. The first criteria I
have solved by using columns for the different designations. The second
criteria is date related. I only want amounts to be added to the first
quarter total IF the date that amount is paid is between 1/1/05 and 3/31/05.
There will be more than one amount for each designation that needs to be
added into the total in the other workbook.