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.

hi.
sorry. such a formula does not exist.
forumla return values. they cannot perform actions like
copy, paste, add values to another cell or workbook ect.
you are looking at a macro to do this.

-----Original Message-----
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.
.