Sumproduct question
 

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

Sumproduct question
 

=SUMPRODUCT(--(H8:H425="DIV"),--(I8:I425=--"2008-4-01"))

--
__________________________________
HTH

Bob

"Jock" wrote in message
...
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

Sumproduct question
 

=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

Sumproduct question
 

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

Sumproduct question
 

Oops I misread as DIV/0 error

=SUMPRODUCT(--(H8:H425="DIV"),--(I8:I425=DATE(2008,4,1)))

If this post helps click Yes
---------------
Jacob Skaria


"Jock" wrote:

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

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