Question #2 of ???

C

Connie Martin

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
 
S

smartin

Connie said:
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
Click to expand...

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

Connie Martin

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Row reference for consecutive series calculation 0
Question 1 of ??? 3
conditional formula with lots of conditions 8
If statements?? 2
Help? I need help in making formulas work to accomplish... 0
Help with year to date comparison 4
Question: How many occurences in date range? 5
Formula to add based on information from 2 different cells 2

Top