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. |
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. . |
All times are GMT +1. The time now is 06:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com