Restated question for formula

V

Vercingetorix.XIII

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
 

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

I need a formula please 6
I need a formula 1
Formula Help for Cumulative Result 5
Formula error 4
I need a formula 4
Formula Reference and VBA 3
if conditional formula required 13
Help with year to date comparison 4

Top