Question #2 of ???
 

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

Question #2 of ???
 

Hi Connie
Try in E10
=SUMPRODUCT((A39:A1000=A10)*J39:J1000)

Regards,
Pedro J.


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

Question #2 of ???
 

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)

Question #2 of ???
 

Thank you. That did it. I just removed the $ from A10 when I dragged it
down. Thank you very much. Connie

"smartin" wrote:

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)

Question #2 of ???
 

Sorry. This gives me #VALUE!. Connie

"Infinitogool" wrote:

Hi Connie
Try in E10
=SUMPRODUCT((A39:A1000=A10)*J39:J1000)

Regards,
Pedro J.


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

Question #2 of ???
 

Connie Martin wrote:
Sorry. This gives me #VALUE!. Connie

"Infinitogool" wrote:

Hi Connie
Try in E10
=SUMPRODUCT((A39:A1000=A10)*J39:J1000)

Regards,
Pedro J.

That looks like an array formula. Try entering the formula by pressing
Ctrl + Shift + Enter.