Hi Guys,
I had this formula in my one of columns:
=SUMPRODUCT(C3:M3,$C$2:$M$2)/(((SUM($C$2:$M$2))-(SUMIF(C3:M3,”NA”,$C$2:$M$2))-(SUMIF(C3:M3,””,$C$2:$M$2))))
Now When I change any cell values on the worksheet normally the figure on the formula should be changing but it doesnt update or refresh the formula some how…
How can I solve this problem….?
Regards,
