G
Guest
Hi, I have a column of $ amounts and corresponding dates
in another column.
Date Amount
1/1/04 $100.00
1/15/04 $100.00
1/31/04 $100.00
On a seperate page I have
Sum for Month
January $200.00
February $100.00
If the date occurs up to and including the 15th of the
month I want to be able to add that $ amount into a cell
which would contain the entire sum for the month. If the
date occurs after the 15th it would need to be added to
the sum of the next month.
in another column.
Date Amount
1/1/04 $100.00
1/15/04 $100.00
1/31/04 $100.00
On a seperate page I have
Sum for Month
January $200.00
February $100.00
If the date occurs up to and including the 15th of the
month I want to be able to add that $ amount into a cell
which would contain the entire sum for the month. If the
date occurs after the 15th it would need to be added to
the sum of the next month.