sumproduct problem
Hi,
I don't understand the format of the date value in column J. Could you
clarify exactly what is in those cells?
Mike
"Norbert" wrote:
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
|