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