Hi Dana,
Let's say you have different columns and the original amount is in column G
and the Past due days in column G1-30 , 31-45, etc. copy the formula as per
below

=SUMPRODUCT(--($H:$H<=30),--($G:$G))

The above formula is if you are using excel 2007 otherwise

=SUMPRODUCT(--($H1:$H1000<=30),--($G1:$G1000))

Copy this formula to the other columns and change 30 by 45, 60 according to
your needs

"DANA" wrote:

Sorry about that.
I have a total that I need to move in the correct aging bucket.

850.00 that is over 66 days past due. I need to move all amounts that are 45
<75 days to the 61-75 day bucket. basic on today date.

=IF(O245<75,N2,"not")
12/31/2008 1 to 45 46 to 75 76to 105 103 to 135 Over- 120
total days past due
$51.50 66




"Luke M" wrote:

I'm afraid that not only am I unable to understand your problem, I don't like
people yelling. Could you try to explain the problem clearer, and turn off
CAPS lock?
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"DANA" wrote:

I HAVE A AGING BUKET WHERE I NEED TO MOVE THE AMOUNT AROUND BY DUE DATE OR
SPECAIL TERMS.

DATE TOTAL DUE CURRENT 31-60 61- 90 91-120 OVER-120.
HERE IS WHAT I HAVE. I GOT THE CURRENT DOWN BUT UNABLE TO GET FORMAT FOR THE
OTHER NEED TO IF A31<61 NEED TO BE ABE TO PULL THE TOTAL DUE TO THAT BUCKET
IF A231<61 N2 NOT...