I need a formula
 

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

I need a formula
 

Perhaps you can restate your problem

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Vercingetorix.XIII" wrote in
message ...
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

I need a formula
 

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.
--
Best Regards,

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


"Vercingetorix.XIII" wrote:

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

I need a 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
"Vercingetorix.XIII" wrote:

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

I need a formula
 

Thank you Luke, It worked when I finally had tinme to sit down and read it,
much appreciated.

"Luke M" wrote:

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.
--
Best Regards,

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


"Vercingetorix.XIII" wrote:

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