SUMPRODUCT with #VALUE error
 

First, thank you in advance for your help.
Can I use SUMPRODUCT to count the number of occurances of a value when there
are errors in the column I want to count?
Example is I was trying this formula to count the number of times J.Doe was
late but there are #Value errors in column V3:V890.
=SUMPRODUCT(--(F3:F890="J.DOE"),--(V3:V890="LATE"))
How do I get around this without deleting the formulas in the cells that
have the error because it will change when other data gets filled in.

Thanks for you help
Joe

SUMPRODUCT with #VALUE error
 

Hi,

Go with :

=SUMPRODUCT(--(F3:F890="J.DOE"),--ISERROR(V3:V890))

HTH

SUMPRODUCT with #VALUE error
 

One way using sum

=SUM(IF(ISERROR(V3:V890="LATE"),0,(F3:F890="J.DOE" )*(V3:V890="LATE")))


entered with ctrl + shift & enter

although it would be much better if you could correct the value errors in
V3:V890 and use your original formula




--


Regards,


Peo Sjoblom


"Joe Gieder" wrote in message
...
First, thank you in advance for your help.
Can I use SUMPRODUCT to count the number of occurances of a value when
there
are errors in the column I want to count?
Example is I was trying this formula to count the number of times J.Doe
was
late but there are #Value errors in column V3:V890.
=SUMPRODUCT(--(F3:F890="J.DOE"),--(V3:V890="LATE"))
How do I get around this without deleting the formulas in the cells that
have the error because it will change when other data gets filled in.

Thanks for you help
Joe

SUMPRODUCT with #VALUE error
 

Thank you for the formula, it worked perfectly.

Joe

"Peo Sjoblom" wrote:

One way using sum

=SUM(IF(ISERROR(V3:V890="LATE"),0,(F3:F890="J.DOE" )*(V3:V890="LATE")))


entered with ctrl + shift & enter

although it would be much better if you could correct the value errors in
V3:V890 and use your original formula




--


Regards,


Peo Sjoblom


"Joe Gieder" wrote in message
...
First, thank you in advance for your help.
Can I use SUMPRODUCT to count the number of occurances of a value when
there
are errors in the column I want to count?
Example is I was trying this formula to count the number of times J.Doe
was
late but there are #Value errors in column V3:V890.
=SUMPRODUCT(--(F3:F890="J.DOE"),--(V3:V890="LATE"))
How do I get around this without deleting the formulas in the cells that
have the error because it will change when other data gets filled in.

Thanks for you help
Joe