M
Miss Candace
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.
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.