Sumproduct question
Mine doesn't
--
__________________________________
HTH
Bob
"Jock" wrote in message
...
Came back with 0 instead of 209.
Thanks for trying though.
--
Traa Dy Liooar
Jock
"Jacob Skaria" wrote:
=SUMPRODUCT(--ISERR(H8:H425),--(I8:I425=DATE(2008,4,1)))
If this post helps click Yes
---------------
Jacob Skaria
"Jock" wrote:
How can I work out the number of times "DIV" appears in H8:H425 when
the date
in I8:I425 is = 01 April 08?
Thanks
--
Traa Dy Liooar
Jock
|