Connie Martin wrote:
I think maybe this will be the last one! Okay, I'll see if I can explain
this one.

In E10 the formula needs to look at the date in A10, find that date in
A39:A1000 and then add the corresponding numbers in J39:J1000. That will be
in the answer in E10.

For example, in A10 the date is 22-Jul-08. In A39:A1000 that date appears
three times and in J39:J1000, the corresponding numbers are 1, 4 and 3.
Therefore the answer in E10 will be 8.

Connie

=SUMIF($A$39:$A$1000,$A$10,$J$39:$J$1000)