Thread
:
Date related IF statement
View Single Post
#
2
Peo Sjoblom
Posts: n/a
=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.
Reply With Quote