You need to check each row from Row 5 to Row 711 in column B to F. Your
problem is withinthat range.

"Gladiator" wrote:

I did not find '#VALUE!' error in the ranges.

"Ayo" wrote:

Look in your ranges for "#VALUE!" if there is one of this in the range you
are applying SUMPRODUCT to, you will get this #VALUE! error. It has happen to
me many times.

"Gladiator" wrote:

Hi all,
This formula sometimes works and sometimes shows #VALUE! error. Please
anyone advice. Thanks.