The formula does not calculate properly... Help me if you could..

X

xokaido

When I click on the formula button it appears all right but does not
calculate values of cells... could anyone help me???
 
X

xokaido

I want to sum column A... Got row with "Total"... When click on the formula
button (on the toolbar) it appears that all`s right...But does not calculate
values (a numbers in the cells)...
 
D

David Biddulph

Make sure your cell isn't formatted as text.
Make sure there aren't spare spaces or other non-printing characters before
the equals sign at the start of the formula.
Press CTRL + ` (grave accent) to toggle between displaying the formula or
its result.
 
Top