Question about Microsoft Excel for PC

1 Answer

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

1 Answer

  • 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
  • 258 Answers

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

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that 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.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

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

1 Answer

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

1 Answer

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

1 Answer

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

1 Answer

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

3 Answers

Excel formula help


formula for the keys or short curt for excel

Jul 15, 2008 | Microsoft Excel for PC

2 Answers

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

1 Answer

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

Not finding what you are looking for?
Microsoft Excel for PC Logo

Related Topics:

956 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18381 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...