Question about Microsoft Excel for PC

# Counting How do I count only the "1"'s in a single row of mixed numbers?

Posted by on

• Kymber Jan 11, 2008

COUNTIF(insert cell range,1)

• Kymber Jan 11, 2008

I had originally want to count "colors", while keeping a running total as the spreadsheet was edited. My macro would count the colors, but not keep the running total. - Plan B is not as "impressive" on my spreadsheet, but I can make the number system work.

• Kymber Jan 14, 2008

That would work if I wanted I didn't have so many rows to do this for - so thanks for trying. I did come with an answer on my own. COUNTIF(insert data range,1). As I stated in the comment above - this was my plan B. It is not as impressive as counting the colored cells in each row, but I couldn't figure out how to keep a running total as my spreadsheet expanded... Plan B works. Thanks, again.

• Heather Bjorkman May 11, 2010

×

• Level 1:

An expert who has achieved level 1.

Hot-Shot:

An expert who has answered 20 questions.

Corporal:

An expert that has over 10 points.

Problem Solver:

An expert who has answered 5 questions.

• Contributor

Do a find and then you will see how many 1's if that is what you search for.

Posted on Sep 20, 2014

• 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

If it isn't too big of a spreadsheet, you can sort it on the column which has the numbers in it, which will put all the 1's in the top of the stack and you can then select just the cells with 1's in them and Excel will count the number of cells that you currently have selected. The number will show up in the Name Box (above cell A1) as: R2 X C2 (for two rows and one column currently selected). Rows are horizontal and columns are vertical.

Posted on Jan 11, 2008

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:

Tip

### Features found on most bill counting machines

Bill and coin counters come with a host of different functions and features that when you learn and master the them you will be a bill counting ninja! There are many terms that you will hear when getting started with your coin counter but the the most important ones are hopper capacity, error detection, adding mode and batch counting.

The hopper is the part of the bill counter that holds the bills that are going to be counted. Bill counting machines have a limit to how many bills the hopper can hold this is known as the hopper capacity. Usually instructions come with a number for how many new bills the hopper can hold, but if you are going to be counting older and crumpled bills that number will be cut in half. So if the capacity is 100 new bills then the number of old bills with around 50.

when you are counting bills its important to watch for error detection on the machine. These errors can be for a feeding error, detection of fake bills or a problem with the sensors in the machine. Machines with error decors are on the higher end but they make troubleshooting easier as well as give you confidence in their counting.

These last two features can be combined into one key feature that makes counting bills with a machine a breeze. Adding and batch counting modes. In a regular mode on a bill counting machine the counter will reset when you finish counting a stack, but if you enable adding mode the counter will continue to count from where the last stack left off.
Batching on the other hand is good for when you have a huge stack of bills like lets say \$5's and you want them to be split into stacks of 10's. You can set the machine to batch count so it will stop counting after 10 bills have passed through. This is really good for if you are stacking bills into increments that are easy to count.

on Nov 14, 2013 | Retail Supplies

### Describe the difference between binary semaphores and counting semaphores.

Binary semaphore is a semaphore with the integer value ranges over 0 and 1 whereas the counting semaphore's integer value ranges over unrestricted domain. Binary semaphores are easier to implement comparing with the counting semaphore.
Binary semaphore allows only one thread to access the resource at a time. But counting semaphore allows N accesses at a time.
The 2 operations that are defined for binary semaphores are take and release.
The 2 operations that are defined for counting semaphores are wait and signal

Sep 25, 2016 | Computers & Internet

### Counting numbers

Counting numbers are any numbers that you can count with. so 1 2 3 4 5 6. This doesn't include decimals or fractions or the number 0.

Jun 07, 2011 | Opt-6 Products MathTasks

### All relays and what there for

Looking over the fender at the fuse box, you see three rows of relays. The first row, closest to the engine, has three relays. Below that are two rows of six relays each. Counting from the left:
Row One 1) Fuel Pump Relay 2) Main Relay 3) Oxygen Sensor Heater
Row Two 4) Horn 5) Tail/Fog Lights 6) Low Beam 7) High Beam 8) Emergency Flasher 9) Heater/AC Blower
Row Three 10) Rear Defogger 11) ABS System 12) ABS Pump 13) Radiator Fan High Speed 14) A/C Compressor 15) Radiator Fan Low Speed
#15 in the lower right corner of the fuse box is the one that seems to take the most grief and fail the most often.

Mar 05, 2011 | 1990 BMW 3 Series

### I need a wiring diagram for the ignition control module and distributor on a 2.8 litre v6 motor

OKAY STANDING IN FRONT OF ENGINE ON LEFT SIDE CYLINDERS FACING YOU IS 1 3 5 ON RIGHT SIDE DRIVER SIDE CYLINDERS FACING YOU IS 2 4 6 LOOKING AT DISTRIBUTOR CAP NUMBER 1 SPARK PLUG ON CAP IN THE 9 OCLOCK POSITION YOUR NUMBER 5 SPARK PLUG ON DISTRIBUTOR CAP IN 6 OCLOCK POSITION .STARTING AT NUMBER 1 SPARK PLUG ON CAP COUNTING CLOCKWISE COUNTING 1 2 3 4 5 6 THATS YOUR SPARK PLUGS WIRES ON CAP TO ENGINE PLUGS. 6 PLUG WIRE ON CAP IS AT 7 OCLOCK POSITION.

Feb 07, 2011 | 1988 Pontiac Firebird

### Situations about real number system

The Real Number System The real number system evolved over time by expanding the notion of what we mean by the word “number.” At first, “number” meant something you could count, like how many sheep a farmer owns. These are called the natural numbers, or sometimes the counting numbers.
Natural Numbers or “Counting Numbers”
1, 2, 3, 4, 5, . . .
• The use of three dots at the end of the list is a common mathematical notation to indicate that the list keeps going forever.
At some point, the idea of “zero” came to be considered as a number. If the farmer does not have any sheep, then the number of sheep that the farmer owns is zero. We call the set of natural numbers plus the number zero the whole numbers.
Whole Numbers Natural Numbers together with “zero”
0, 1, 2, 3, 4, 5, . . .

Jun 22, 2010 | Google Chrome

### What is the meaning of whole numbers?

no decimals (1.5, .56) no fractions (1/2, 1 3/4)

whole numbers are just whole numbers
1, 2, 3 and on 9,10,11 .....

not
1.5, 2.5, 2.356
1 1/5, 2 2/6,3 1/5

Jun 19, 2010 | Mathsoft StudyWorks! Mathematics Deluxe...

### Jumpers guide Maxtor 2B020H1 20Gb Slim IDE 3.5'' Hard Drive

Maxtor jumper as follow:
looking at the connector top row 5 pins, buttom row 4 pins.
the single pin on the top row is index pin.
master jumper is located between top 2nd pin and 1st buttom, counting from the left.
slave has no jumper on any of the pins.
cable select jumper is located between top 4th and buttom 3rd pin. counting from the left.

Apr 24, 2009 | Computers & Internet

#### Related Topics:

103 people viewed this question

Level 3 Expert

Level 3 Expert