View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Norbert[_2_] Norbert[_2_] is offline
external usenet poster
 
Posts: 31
Default sumproduct problem

In column J I have stored different codes (numerical)
for each code a date is stored in column N
There can be more of the same codes in column J

I'd like to know how many times code "3" is found in column J,
whereby the associated date is greater than (date_no+17.5/24)

Can this be done?

Thanks
Norbert