I need a formula

  • Thread starter Thread starter Vercingetorix.XIII
  • Start date Start date
V

Vercingetorix.XIII

that will look through 2 columns for a date and add the figures in another
column into a cell for that date. sumif comes up w/some strange results
example:

Dec name amount payment1 payment2
1st 100.00
5th client 100.00 dec1 jan 1
10th
20th
25th

Jan
1st 100.00
5th
 
You have posted this question 4 times, across multiple forums. When you
oringally post, you can submit to mutliple groups so that we all see
everyone's answers. Please stop reposting the same question.
 
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
 
Thank you Luke, It worked when I finally had tinme to sit down and read it,
much appreciated.
 
Back
Top