SUMPRODUCT with #VALUE error

  • Thread starter Thread starter Joe Gieder
  • Start date Start date
J

Joe Gieder

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
 
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
 
Back
Top