View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim
 
Posts: n/a
Default 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