Question about Microsoft Office Standard for PC

# 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

×

• Level 1:

An expert who has achieved level 1.

Corporal:

An expert that hasĀ over 10 points.

Mayor:

An expert whose answer gotĀ voted for 2 times.

Problem Solver:

An expert who has answered 5 questions.

• Contributor

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

×

SOURCE:

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:

### Hello, I need a program for converting from Excel to VCF format. There are about 300-400 numbers in total and will be added. dissolves from xls in a vcard and most importantly Free.

This conversion is possible with osttopstapp tool. This software will help you to migrate mailboxes databases from XLS to VCF File format. You can download free tool from here http://www.osttopstapp.com/xlstovcf.html
http://www.osttopstapp.com/xlstovcf.html

May 25, 2018 | Excel Computers & Internet

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

appliancepartspros...
Search Over 2 1 Million Appliance Parts

- repairclinic.com
- ezapplianceparts.com
- partssellect.com

Appliance Parts Lawn Mower Parts Heating Cooling Parts 365 day returns

Mar 31, 2016 | Microwave Ovens

### 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
http://www.simpleocr.com/OCR_to_Excel
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...

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

### Cant get the Indian rupee format in EXCEL.

With Excel Password Recovery 5.0, you can open you excel spreadsheet without data lost.

Sep 14, 2010 | Microsoft Excel for PC

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

go to searspartsdirect.com

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

### 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 http://www.andrewselectronics.com/welcome.aspx
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

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

### Regarding Excel formulas

Yes, its possible by designing a formula in excel.

Aug 03, 2008 | Microsoft Windows XP Professional

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

#### Related Topics:

135 people viewed this question

Level 3 Expert

Level 3 Expert