When you select some data in excel , you can come to know the count , sum , average , range ,min ,max .The same appears below scroll bar . It has suddently disappeared from my workbook .Hence very difficult to work .plz help
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
Average is total divided by count. So add up all the values for the two years and divide by 24 months. You could also just select the entire column of values and Excel will show the average in the status bar at the very bottom. If not, right click the status bar and select Average.
I don't have 2010, but I do have 2007. Now, provided that status bar is still there, right click on it and check the boxes you want to show on your status bar, such as sum, count, etc.
If you status bar is not there, make sure your are in NORMAL view and not Full Screen View. Hit the escape key a few times to get back to Normal. It would also be a good idea to click on the View ribbon menu to see what view you are in.
Use the function =sum() to add numbers. To sum, for example, all of column A, enter in the formula bar =sum($A:$A). You can use the subtotal function within the range you are adding and the answer will not count towards the final total.
You can make a link into cell that you want by right mouse click
Heperlink, link to , place in thins document , on the feild type the cell reference (A22 ,E56) ...etc , & link where is the cell that you want link to . & in which sheet it is .