Date related IF statement
 

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.

=SUMPRODUCT(--(Dates=--"01/01/05"),--(Dates<=--"01/31/05"),Range_to_Sum)+wh
atever cell you want to add this to

--

Regards,

Peo Sjoblom


"Miss Candace" <Miss wrote in 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.