Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
=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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date related IF statement | Excel Worksheet Functions | |||
date and time | New Users to Excel | |||
Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel |