Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |