Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!!!!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Subtraction formula for consecutive cells in a column, skipping blanks | Excel Worksheet Functions | |||
Need a 1 Column multiplication formula for 2600 cells. How? | Excel Worksheet Functions | |||
count non blank cells which meet criteria in another column | Excel Worksheet Functions |