I tried the formula below and I am receiving a 0 value when the data cell is
blank.
"Peo Sjoblom" wrote:
One possible way
=IF(COUNTBLANK(INDEX(A3:E6,0,MATCH(B7,A2:E2,0)))=4 ,"",SUMPRODUCT(($A$3:$A$5=$A$8)*($B$2:$E$2=$B$7)*( $B$3:$E$5)))
--
Regards,
Peo Sjoblom
(No private emails please)
"joshmd9909" wrote in message
...
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
|