SUMIF
 

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

Is there any solution?

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

"SUMIF" wrote:

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

Is there any solution?

Hi, Frank

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

Keith
Hong Kong, China

"Frank Kabel" wrote:

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

"SUMIF" wrote:

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

Is there any solution?

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=243495


--
keith
------------------------------------------------------------------------
keith's Profile: http://www.excelforum.com/member.php...o&userid=16242
View this thread: http://www.excelforum.com/showthread...hreadid=276203