SUMIF

S

SUMIF

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

Is there any solution?
 
F

Frank Kabel

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

SUMIF

Hi, Frank

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

Keith
Hong Kong, China
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combine Sumifs with Subtotal 0
Use TODAY() function as the criteria in a SUMIF formula 1
sumif issues 1
Multiple Columns in Sum Range using SUMIFS 1
quick question on sumif 3
SUMIF with criteria "<>" & "=" 4
Have the SUMIF result (formula) on a separate sheet/tab 2
SUMIF over multiple spreadsheets 4

Top