View Single Post
  #1   Report Post  
joshmd9909
 
Posts: n/a
Default IF Statement Question 0 values & blank cells

Here is my formula:

IF(SUMPRODUCT(($A$3:$A$5=$A$8)*($B$2:$E$2=$B$7)*($ B$3:$E$5))="","",
SUMPRODUCT(($A$3:$A$5=$A$8)*($B$2:$E$2=$B$7)*($B$3 :$E$5)))

I get a 0 value for a blank cell.. I would like nothing returned for a
blank cell.

If I use =0, "", I will not receive a value for cells that have a 0 in them.

Help!
Thanks,
Josh