Question about Microsoft Office Standard for PC

1 Answer

Excel I have a list of 300 numbers and I need to find out how many are between 0 and 10 and then 10 and 20 and so on up to the highest number possible which is 400. Is it possible to do this on excel

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.


    An expert that hasĀ over 10 points.


    An expert whose answer gotĀ voted for 2 times.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 14 Answers
Re: excel

See if this is possible using the COUNTIF formula in Excel. Example: My range is A1:A20. Lowest number being 1 and highest number being 20. To see how many are less than 10 I'd use: =COUNTIF(A1:A20,"<=10") To see how many are less than 20 but greater than 10 is a little different. (And this might be the crazy way). I do this: =SUM(COUNTIF(A1:A300,"<=20") - COUNTIF(A1:A300,"<=10")) Try this and see if it works for you. It seemed to work fine for me.

Posted on Sep 23, 2007

Add Your Answer

0 characters

Uploading: 0%


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


3 Points

Related Questions:

1 Answer

How do i select the lowest 3 numbers from a list of 4 numbers

type =MIN(B1:B4). if the 4 numbers is in the cell b1 to b4, else, name the cell number.

Nov 15, 2011 | Microsoft Excel for PC

1 Answer

I am trying to type numbers with more than 3 digits and the program changes them to 3 digits, for example: typing 30000 , appears 300 in the cell. help!

  1. Right click on the the letter at the top of the column you are entering the larger numbers in and choose "format cells" from the drop down menu.
  2. Then click on "number" and this is where you can set the number of decimal places or other adjustments.

Feb 25, 2011 | Microsoft EXCEL 2004 for Mac

2 Answers

What is the function of Microsoft excel?

Ok - if your question is "What is Excel" - then the answer is that it is a spreadsheet program that allows you the ability to compute data (usually numbers) for example, pulling together a list of hours worked by employees and adding them up automatically. It also can be used to develop sophisticated computational models and I have used it to develop professional services proposal sizing tools using formulas and functions ... which is a good segwey into my other answer.

If your question is "what is a function or formula in Excel" - then the answer is a function or formula in Excel is a collection of mathematical, text, statistical, etc. preprogrammed tools that allows you to manipulate the data you have in your spreadsheet e.g. a SUM() function that adds a series of numbers, and AVERAGE() funtion that computes the average of a series of numbers, etc.

Hope that helps!



Oct 01, 2010 | Microsoft Office Excel 2007 Upgrade:...

2 Answers

Cant get the Indian rupee format in EXCEL.

there is a popular solution for those who have been locked out by excel spreadsheet. For this solution, what you need is a password recovery tool,Google Excel Password Recovery 5.0 for password recovery. Download and install the software.
With Excel Password Recovery 5.0, you can open you excel spreadsheet without data lost.

Sep 14, 2010 | Microsoft Excel for PC

3 Answers

How to round the fig. in Excel 2007 E.g. 12350*32.75% = 4044.625 I want it to be rounded to nearer rupee. If the decimal is lesser than 50, rounded fig. should be lower Rupee if the decimal is more than 50...

The function is called ROUND. It has 2 arguments, (1) the original number and (2) the number of decimal digits. Here is the Excel's help: ROUND(number,num_digits) The number you want to round. None. num_digits The number of digits to which you want to round number. If num_digits is greater than 0 (zero), then number is rounded to the specified number of decimal places. If num_digits is 0, then number is rounded to the nearest integer. If num_digits is less than 0, then number is rounded to the left of the decimal point.
So for your case use this in a cell "=ROUND(12350*32.75%, 0)" without quotes, where I assume one or both numbers will come from other cells. -Ken

Aug 29, 2009 | Microsoft Office Excel 2007

1 Answer

Multiply a value by a minimum amount

You need a cell to put these numbers first. Lets say A1 is your reference cell where the numbers are going to be input. B1 is the cell that you are going to see the calculation. Type the following formula in B1


after doing this you can put any number in A1 and it will give you the calculation in B1 as the way you wanted.

Feb 24, 2009 | Microsoft Excel for PC

1 Answer

Excel Formula

Highlight the range of cells that contain the numbers you want included. Click on the cell where you want the highest value displayed. Click on the paste function button select MAX and click <OK>

Jan 16, 2009 | Microsoft Excel for PC

1 Answer

Need a range answer in excel

Yes, Concatenate is the name of the formula.

=CONCATENATE(.15*B27," to ",.25*B27)
Which would return something like: "15.1254 to 25.5514"

If you want to limit the numbers in the returned data to whole numbers, you need to add the Floor formula.
=CONCATENATE(FLOOR(.15*B27,1)," to ",FLOOR(.25*B27,1))
That would return something like "15 to 25"

Dec 19, 2008 | Microsoft Excel for PC

2 Answers

Can't reopen circular reference file in excel

  1. Click the Microsoft Office Button , click Excel Options, and then click the Formulas category.
  2. In the Calculation options section, select the Enable iterative calculation check box.
  3. To set the maximum number of times that Excel will recalculate, type the number of iterations in the Maximum Iterations box. The higher the number of iterations, the more time that Excel needs to calculate a worksheet.
  4. To set the maximum amount of change you will accept between calculation results, type the amount in the Maximum Change box. The smaller the number, the more accurate the result and the more time that Excel needs to calculate a worksheet.

Nov 05, 2008 | Microsoft Excel for PC

1 Answer


Are you looking to solve any particular problem?--- because there are a huge number of possible formulas in Excel.

However, in my opinion, the most commonly needed ones are addition, subtraction, division, multiplication, and summing.

Suppose you have the following numbers typed into your Excel spreadsheet:

columns: A B C D
1 20 3
2 10 4
3 15 2
4 1 2 3

Then suppose you type in the following formulas (in the D column):

columns: A B C D
1 20 3 =A1+B1
2 10 4 =A2-B2
3 15 2 =A3*B2
4 1 2 3 =sum(A4:C4)

Then the following answers will appear in the D column:

columns: A B C D
1 20 3 23
2 10 4 6
3 15 2 30
4 1 2 3 6

Sep 29, 2008 | Microsoft Business & Productivity Software

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

117 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18258 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides