On Mon, Mar 28, 2005 at 10:30:59AM +0700, arief# wrote:
>
> Dear all.
>
>
> What happened in Gnumeric 1.4.3, why does my formulas suddenly gone mad?
>
>
> This formula was okay before I upgrade,
> =if(sumif('Traffic Prediction'!$B$3:$B$739,$A25&B$4,'Traffic
> Prediction'!$D$3:$D$739)+sumif('Traffic Prediction'!$B$3:$B$739,B$4&
> $A25,'Traffic Prediction'!$D$3:$D$739)<=0,"",sumif('Traffic Prediction'!
> $B$3:$B$739,$A25&B$4,'Traffic Prediction'!$D$3:$D$739)+sumif('Traffic
> Prediction'!$B$3:$B$739,B$4&$A25,'Traffic Prediction'!$D$3:$D$739))
>
> after upgrade it is now generate #VALUE! errors.
known problem. Some fixes in SUMIF and COUNTIF made the test for 3d
references somewhat overzealous. I'll make up a patch tonight.
_______________________________________________
gnumeric-list mailing list
[email protected]
http://mail.gnome.org/mailman/listinfo/gnumeric-list
