| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| where can I see my question and answer? Yesterday I ask a question | Excel Discussion (Misc queries) | |||
| QUESTION | Excel Discussion (Misc queries) | |||
| Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
| an if question | Excel Discussion (Misc queries) | |||
| The question is an excel question that I need to figure out howto do in excel. | Excel Worksheet Functions | |||
Linear Mode
