Date related IF statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using SUMIF to add data between a range of dates 2
Calculate elapsed time excluding specific timeframe 10
match total with fees 2
sum of mutiple entries on another workbook 6
Sum amounts based on date field 6
Between dates 2
help with lookup reference please 10
If Statement ? Seperate cost over years of project 1

Back
Top