sumif calculate

S

SUMIF

I used too many "SUMIF" functions in the file.

It is still work. But the status showed "Calculate" made me not confidence.

Do have any solutions ?
 
G

Govind

Hi,

The Auto calculate function is off.

Go to Tools ->Options -> and choose the tab calculation.

Check the Automatic radio button in that tab.

Regards

Govind.
 
Top