J
Jock
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
in I8:I425 is => 01 April 08?
Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jacob Skaria
=SUMPRODUCT(--ISERR(H8:H425),--(I8:I425>=DATE(2008,4,1)))
If this post helps click Yes
If this post helps click Yes
J
Jock
Came back with 0 instead of 209.
Thanks for trying though.
Thanks for trying though.
J
Jacob Skaria
Oops I misread as DIV/0 error
=SUMPRODUCT(--(H8:H425="DIV"),--(I8:I425>=DATE(2008,4,1)))
If this post helps click Yes
=SUMPRODUCT(--(H8:H425="DIV"),--(I8:I425>=DATE(2008,4,1)))
If this post helps click Yes
B
Bob Phillips
Mine doesn't