I have searched the boards trying to find an answer to this but with no luck.

My formula is as follows:

=SUMPRODUCT((VALUE($E$11:$E$65435)>=$C13)*(VALUE($E$11:$E$65435)<=$D13)*(VALUE(O$11:O$65435)>0))

This works for most of my data, however this particular column (column 0) contains a formula that must have some errors present - these are hidden with ISERROR, but I think my calculations still finds them.

So my question is, how do I sum column $0 even though it contains #value! in some of those cells?

Many thanks in advance

Humate