SUMIF

[SUMIF]

I used many "sumif" functions in my worksheet and it is workable. BUT
"calculate" appear in status bar.

Is there any solution?

 

[Frank Kabel]

Hi
check 'Tools - Options - Calculate' and check that automatic calculation is
enabled

 

[SUMIF]

Hi, Frank

Thanks advance. I am sure that it is "AUTOMATIC" mode.

Keith
Hong Kong, China

 

[keith]

Calculation takes forever, MS KB Q243495 XL2000:
Calculate Message Remains in Status Bar If 65,536 Formula
References (Xl97 and XL2000),
http://support.microsoft.com/default.aspx?kbid=24349