View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Connie Martin Connie Martin is offline
external usenet poster
 
Posts: 251
Default 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