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

  • huggie1 Oct 02, 2007

    thanks tready29483, your solution worked a treat, sorry for not getting back and telling you sooner. Huggie1



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

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



1 Suggested Answer

  • 2 Answers

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

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.
Good luck!

Posted on Jan 02, 2017


Add Your Answer

Uploading: 0%


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



Related Questions:

1 Answer

Where can I get main board diagram with parts list for an unidentified microwave oven?

Hello Danielle Carter,

Fact is... you are not looking for a fuse...

You need t know why that fuse OPERATED (Blow'd)...

Before we start...
An annoying little known trivia about micro-waves...
If used for EMPTY or for softening single pats of butter
they will soon self destruct (eat themselves... burn-out... fail).

When they do... their "micro-wave-generator" (magnetron) will
consume much more energy and cause the primary (most likely solitary fuse to operate)... "blown fuse".

Would that you had included a model number... (but alas)...

Unidentified... indeed!

Looking up your own model number on eBay or better GETTING your REAL PART NUMBER off of your original parts sheet will allow you to shop for the VERY BEST PRICE.

Sears has an excellent reference library... but if you want the same part you can get everywhere else for the HIGHEST price
SEARs ($$$$) is (not) your place...
(3 estimates... always!).

Don't forget to get that SPARE FUSE...!

Happy hunting.

Search Over 2 1 Million Appliance Parts


Appliance Parts Lawn Mower Parts Heating Cooling Parts 365 day returns

Mar 31, 2016 | Microwave Ovens

1 Answer

I have a project going in my company. I want psion teklogic to automatically send the scanned data into Excel. Please help me in understanding how can I do this ?

you may need an ocr to excel software converter
in excel you would have a work book that you put the resulting scan into as an excel format. Then you have another workbook that is referenced to the workbook and particular cell with part number
then you would have a workbook with a list of cells part number and pdf files .
then lookup function would take part number and use it to lookup from the reference list.

Mar 28, 2014 | Psion Teklogix 7535 G1 WiFi PDA w/Long...

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

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

1 Answer

I need parts number for the two bricks located under element of Turbochef model ngc

go to

put in your model number and you will get their complete and excellent schematic, parts list and parts numbers. J.

Jun 16, 2010 | Microwave Ovens

1 Answer

New a new mirror for my dlp its the large mirror on the back pannel

You can order the mirror from the following site.
Their site is
And their phone number is a 24-Hour Order Desk: (800) 274-4666
I recommend the phone order so you can talk to the person about price and availability.
The site list price is $166.83, but they show that it is not in stock, possibly order item only.

If you use the site to look up the part do not use the dash in the model number.

I hope this information allows you to resolve this issue.
If I have helped you, please help me, and rate this suggestion the highest FixYa rating. (Two Thumbs Up)
Please Note: If you cannot rate this post with the highest rating, then please do not leave any rating. I am doing this for free and I do not think that any rating other that the best is needed.
If you need further assistance please comment to this post and I will try to help you further.

Jul 14, 2009 | Panasonic PT-56DLX75 56" HDTV

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

2 Answers

Regarding Excel formulas

Yes, its possible by designing a formula in excel.

Aug 03, 2008 | Microsoft Windows XP Professional

2 Answers

Excel - Automatically update invoice numbers

Yes but You need to tell your exact requirements eg. from where you would like to update your Invoice Template i.e from A Separate Database or from a Dropdown List etc

May 14, 2008 | Microsoft Excel 2000 Step by Step...

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

129 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2970 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18419 Answers

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

Answer questions

Manuals & User Guides