Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Restated question for formula
The payments are split into 2- 1 month apart- I need a formula which will add
the payments to be made on Nov 1 into a cell for Nov1st - then add the payments for Dec 1 into a cell for dec. 1st. So, possibly my spreadsheet needs redesigned, I merely need to scan 2 columns for dates and add the payments from another column and possobly a list of names into another... Date Amnt name Amt 2 pymnts 1st pmt 2nd pmt 1 Nov 1 $225.00 Client 1 550.00 225.00 Nov 1 Dec 1 2 Nov 5 $300.00 Client2 700.00 350.00 Nov 5 Dec 5 3 Dec 1 $225.00 4 Dec 5 $300.00 5 Nov 20 $0.00 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Restated question for formula
Please stay in your original thread
-- Kind regards, Niek Otten Microsoft MVP - Excel "Vercingetorix.XIII" wrote in message ... The payments are split into 2- 1 month apart- I need a formula which will add the payments to be made on Nov 1 into a cell for Nov1st - then add the payments for Dec 1 into a cell for dec. 1st. So, possibly my spreadsheet needs redesigned, I merely need to scan 2 columns for dates and add the payments from another column and possobly a list of names into another... Date Amnt name Amt 2 pymnts 1st pmt 2nd pmt 1 Nov 1 $225.00 Client 1 550.00 225.00 Nov 1 Dec 1 2 Nov 5 $300.00 Client2 700.00 350.00 Nov 5 Dec 5 3 Dec 1 $225.00 4 Dec 5 $300.00 5 Nov 20 $0.00 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Question | Excel Discussion (Misc queries) | |||
Formula Question | Excel Discussion (Misc queries) | |||
Formula Question | Excel Discussion (Misc queries) | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
Formula question | Excel Discussion (Misc queries) |