excel sumproduct value error

  • Thread starter Thread starter cstang
  • Start date Start date
C

cstang

Hello,

Can anyone pls help me?
The below formula return #VALUE! error.
=SUMPRODUCT(($H4=$B$52:$B$2000)*(J$3=$E$52:$F$2000)*($G$52:$G$2000))

But when I change to:
=SUMPRODUCT(($H4=$B$52:$B$500)*(J$3=$E$52:$F$500)*($G$52:$G$500))
It works

What is the problem with the formula?
Thanks in advance.
Cstang
 
Do you have any errors in rows 501:2000 in columnd B, E, F or G?

Do you have any non-numeric values in G501:G2000?
 
Back
Top