Question about Microsoft Excel for PC

# Count , sum ect below scroll bar disappeared

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

Posted by on

• Level 2:

An expert who has achieved level 2 by getting 100 points

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

Vice President:

An expert whose answer got voted for 100 times.

• Expert

Excel 2007 - This is called the status bar, right click on it if it is blank and put click to put a click next to the options you require.
Previous Versions - Click View --> Status Bar

Posted on Jan 19, 2009

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### I need to take the 2 year average of 2014 to 2015. How would i do this?

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.

Sep 16, 2015 | Microsoft Office Excel 2007

### How to find the average

I gather you might be looking for a spreadsheet formula to do this (I could be wrong tho)
here we go
=sum(a1:a10)/count(a1:a10)
a1:a10 is the range of cells you want to find the average of and using the count function means it works even if there are empty cells in the range

hope this is what you're looking for

May 30, 2011 | Computers & Internet

### 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...

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.

After that, I am at a loss to assist you.

Feb 24, 2011 | Microsoft Excel for PC

### Excel Formula

With data in A1 to C1: A2 =IF(A1>0,1,0) B2 =IF(B1>0,1,0) C2 =IF(C1>0,1,0) A3 =SUM(A2:C2)

Jun 04, 2009 | Microsoft Office Excel 2007

### CAN GET COLUMNS TO ADD UP AND GIVE TOTAL ONLY GET SUBTOTALS

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.

Mar 14, 2009 | Microsoft Excel for PC

### Excel formula help

formula for the keys or short curt for excel

Jul 15, 2008 | Microsoft Excel for PC

### Min and Max Date range filter

Check out: Tools -> Data -> Filter -> Auto Filter.
You may want to look at the help function to get a better idea of how powerful this feature is.

Let me know if this helps.

May 08, 2008 | Microsoft Excel for PC

### Excel and the AVERAGE function

Here is one way:

In this example, my numbers are in cells a1 through a4. My average is computed with the formula:

=SUM(A1:A4)/COUNTIF(A1:A4,"<>0")

I'm summing the range of numbers and dividing that by the count of nonzero numbers. With this formula, you'll get an error if there are no nonzero numbers.

Dec 30, 2007 | Computers & Internet

#### Related Topics:

957 people viewed this question

Level 3 Expert

Level 3 Expert