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

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

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