Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula That Totals Extracted Values
Column A is the Ticket Date of Service, Column B is Ticket Date Entered.
Column C is the number of tickets entered on the Date in Column B for the date in Column A. Column D is Date Entered minus Date of Service using networkdays. In Column E are formula's that extract the unique numbers from Column D. I now need formula's in Column F to find each occurrence of a number in Column E from Column D and add the number of tickets in Column C. That is: I need to know how many tickets were entered X days after the Date of Service. For example: In Column E, the following numbers were extracted from Column D: 3, 4, 5, 7, 8 and 10. I need to know how many tickets were entered 3 days after the date of service, 4 days after, 5, 7, 8 and 10 days after. These numbers may occur multiple times in Column D. I sure hope this makes sense. Everyone here has been so helpful and I'm hoping someone can assist me with this last formula. Thank you, Diane |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula That Totals Extracted Values
Look in Help for SUMIF, along the lines of
=SUMIF(E:E,3,C:C) -- HTH, Bernie MS Excel MVP "LDL" wrote in message ... Column A is the Ticket Date of Service, Column B is Ticket Date Entered. Column C is the number of tickets entered on the Date in Column B for the date in Column A. Column D is Date Entered minus Date of Service using networkdays. In Column E are formula's that extract the unique numbers from Column D. I now need formula's in Column F to find each occurrence of a number in Column E from Column D and add the number of tickets in Column C. That is: I need to know how many tickets were entered X days after the Date of Service. For example: In Column E, the following numbers were extracted from Column D: 3, 4, 5, 7, 8 and 10. I need to know how many tickets were entered 3 days after the date of service, 4 days after, 5, 7, 8 and 10 days after. These numbers may occur multiple times in Column D. I sure hope this makes sense. Everyone here has been so helpful and I'm hoping someone can assist me with this last formula. Thank you, Diane |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula That Totals Extracted Values
Thanks, Bernie. Diane
"Bernie Deitrick" <deitbe @ consumer dot org wrote in message ... Look in Help for SUMIF, along the lines of =SUMIF(E:E,3,C:C) -- HTH, Bernie MS Excel MVP "LDL" wrote in message ... Column A is the Ticket Date of Service, Column B is Ticket Date Entered. Column C is the number of tickets entered on the Date in Column B for the date in Column A. Column D is Date Entered minus Date of Service using networkdays. In Column E are formula's that extract the unique numbers from Column D. I now need formula's in Column F to find each occurrence of a number in Column E from Column D and add the number of tickets in Column C. That is: I need to know how many tickets were entered X days after the Date of Service. For example: In Column E, the following numbers were extracted from Column D: 3, 4, 5, 7, 8 and 10. I need to know how many tickets were entered 3 days after the date of service, 4 days after, 5, 7, 8 and 10 days after. These numbers may occur multiple times in Column D. I sure hope this makes sense. Everyone here has been so helpful and I'm hoping someone can assist me with this last formula. Thank you, Diane |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automate replace values in formula | Excel Discussion (Misc queries) | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
How do I copy cell values (derived from formula), not references? | Excel Worksheet Functions | |||
Formula to compare multiple rows values based on another column? | Excel Worksheet Functions |