excel sumproduct value error

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
 
D

Dave Peterson

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel sumproduct value error 6
Scrabble Value calculation for Welsh words 0
Sumproduct 3
Excel Countifs/Sumproduct with mutil Or statement 3
is Retrieving a Cell address from a cell containing a SUMPRODUCTformula a problem ? 5
=SUMPRODUCT((Data1!$B$1:$B$500="March")*(Data1!$C$1:$C$500="New 3
How to make worksheet name as variable? 4
SUMPRODUCT to test two conditions 11

Top