I want to total the amounts between certain dates. I have a list of dates
that each bill is due, the 1st, the 9th, the 12th, the 18, the 20th etc......
A has the Date, B has the bill, C has the amount. E has been filled with
dates 2 weeks apart, this is when we pay bills. I want Excel to look at the
date in E and have it compare it to the bill dates in A, and total the amount
that needs to be paid during that cycle. For example, if we pay on the 2nd
and then again on the 16th, I want to know the total of what is due between
the 2nd and the 16th.

this is the idea. modify to suit
=sumproduct((a2:a22b1)*(a2:b22<=b2)*b2:b22)

--
Don Guillett
SalesAid Software

"KPyle" wrote in message
...
I want to total the amounts between certain dates. I have a list of dates
that each bill is due, the 1st, the 9th, the 12th, the 18, the 20th
etc......
A has the Date, B has the bill, C has the amount. E has been filled with
dates 2 weeks apart, this is when we pay bills. I want Excel to look at
the
date in E and have it compare it to the bill dates in A, and total the
amount
that needs to be paid during that cycle. For example, if we pay on the 2nd
and then again on the 16th, I want to know the total of what is due
between
the 2nd and the 16th.

Thanks for the quick response,
That works if the date is laid out down the line as the actual due date i.e.
2/1/07
2/9/07
2/12/07
but they are in the sheet just once at the top as just the day of the month
that they are due, as they are due every month, every year on the same date.
A B C
Due Bill Amount
1 bill a 2000.00
9 bill b 5000.00
12 bill c 8000.00
18 bill d 4000.00
20 bill e 3000.00

Then in column E from the top of the page on down filled in every two weeks
is the date we pay out and in F we total the amount that is to be paid:
E F
2/02/2007 $13000.00
2/16/2007 $9000.00
3/02/2007 $13000.00
3/16/2007 $7000.00
3/30/2007 $15000.00

Is there any way to make it look at the day of the month, 1-31, to determine
if it is due? Or do I need to redo my entire sheet?

Thanks so much for your help!!
Kerri

"Don Guillett" wrote:

this is the idea. modify to suit
=sumproduct((a2:a22b1)*(a2:b22<=b2)*b2:b22)

--
Don Guillett
SalesAid Software

"KPyle" wrote in message
...
I want to total the amounts between certain dates. I have a list of dates
that each bill is due, the 1st, the 9th, the 12th, the 18, the 20th
etc......
A has the Date, B has the bill, C has the amount. E has been filled with
dates 2 weeks apart, this is when we pay bills. I want Excel to look at
the
date in E and have it compare it to the bill dates in A, and total the
amount
that needs to be paid during that cycle. For example, if we pay on the 2nd
and then again on the 16th, I want to know the total of what is due
between
the 2nd and the 16th.