Need formula that will sum cells in a column bases on criteria in other cells.
 

Here is my problem.

Column A is a rolling calender in number format

Column B is the date of payment or payments in number format. These
payments are in order but have random dates with multipule payments on
some days.

Column C is the amount of payment for corresponding date in column B

I am looking to creat a new column that corresponds with the date in
columnn A and adds all payments for that day if any.

The content in columns A,B&C will be changing on a daily basis.

I thank you very much for any help that you may prvide with this
problem!!

Jim

Need formula that will sum cells in a column bases on criteria in other cells.
 

Assume the values start in row 2, new column data in D2, put this in D2

=SUMIF($B$2:$B$100,A2,$C$2:$C$1000)

copy down

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon




"Jim" wrote in message
ups.com...
Here is my problem.

Column A is a rolling calender in number format

Column B is the date of payment or payments in number format. These
payments are in order but have random dates with multipule payments on
some days.

Column C is the amount of payment for corresponding date in column B

I am looking to creat a new column that corresponds with the date in
columnn A and adds all payments for that day if any.

The content in columns A,B&C will be changing on a daily basis.

I thank you very much for any help that you may prvide with this
problem!!

Jim

Need formula that will sum cells in a column bases on criteria in other cells.
 

This almost works, It skips every other cell in column D and doubles
the size the cell that it works in. When tabing down column D, two
rows are highlighted over on the left row header. It is calculating
half of the days, but the rows do not corresppond with the date in
column A.

Jim

Need formula that will sum cells in a column bases on criteria in other cells.
 

Peo, I got it working. Thank you very much for you help!!!!