#VALUE! ERROR

G

George

Why am I getting a #VALUE! in a blank cell with the following formula:

=SUMPRODUCT((G32*4+H32*2)*(IF($A32="","",SUMPRODUCT((Sheet1!$A$2:$A$26=$A32)*(Sheet1!$G$2:$G$26)))))
 
D

Dave F

Because you're trying to multiply a range by a blank. You can't multiply
blanks; they are valueless.

Better to do something like this:

=IF(ISBLANK($A32),"",[your SUMPRODUCT formula])

Dave
 
Top