Home |
Search |
Today's Posts |
#1
|
|||
|
|||
SUMIF
I used many "sumif" functions in my worksheet and it is workable. BUT
"calculate" appear in status bar. Is there any solution? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF with only one criteria cell within range | Excel Discussion (Misc queries) | |||
creiteria in sumif | New Users to Excel | |||
Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions | |||
How I use SUMIF & AND | Excel Worksheet Functions | |||
Conditional Format With SUMIF | Excel Worksheet Functions |