Problem in functions

[Closed]
Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
Hello,

I have problem doing calculation in excel functions, whenever i type a function, i dont get the result of the function but i get the function itself. say i want to add cell B:5 to f:5 so i did =sum(B:5 f:5) but instead of the answer,I get the function displayed as at is i.e =sum(B:5 f:5) and not the result. I am using Excel 2007...Please let me know where is the problem..

1 reply

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Change the cell formatting to "General" It should not be in "Text" format
One more thing to get some just use =sum(B5:f5)