Question about Microsoft Excel for PC

2 Answers

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

Posted by on

2 Answers

  • Level 1:

    An expert who has achieved level 1.


    An expert who has answered 20 questions.


    An expert that has over 10 points.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 23 Answers
Re: Counting

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


    An expert that got 10 achievements.


    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Expert
  • 265 Answers
Re: Counting

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

Add Your Answer

0 characters

Uploading: 0%


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


3 Points

Related Questions:

1 Answer

How to stop an If count statemnt?

One appraoch that comes to mind is to nest an AND function into your IF statement along the lines of IF(AND(Test1isTrue, NOT(ProductColleccted)), TrueAction, FalseAction)

May 02, 2015 | Microsoft Excel for PC

1 Answer

How can I count all the pages of more than 16000 documents in a folder. They are *doc and *.docx files.

The number of pages (printed?) would be a function of font size & margins. The number of words would be easier to get a handle on using something like
or the word counting feature in WORD.
Unfortunately you'd have to open the files to get a count; easy for a few but not so easy for 16,000 files. :(
You could 'count' a sampling of files, then estimate the rest based on file size to word count correlation.

Or you could 'print' the files to PDF & then merge them into a single PDF document. This would give a better printed page count. The could be done on a sampling basis.

Dec 25, 2014 | Microsoft Office Professional 2007 Full...

1 Answer

What is the meaning of rows?

In Microsoft Excel, "rows" refer to data cells grouped together horizontally across a single line. The numbers on the far left of the screen refer to a row number. Similarly, the letters at the top of the workbook page refer to the columns.

Here is a picture to help:

In this example, there are 3 rows. All the cells in Row 1 contain the words "Row 1" and are color-coded orange. Likewise, All the cells in Row 2 are pink, and those in Row 3 are blue. Do note, however, that even though the boxes under the letter "F" aren't color-coded, they are still in the respective rows. Each color-coded line could extend for an infinite number of boxes, and each box of the same color would be part of that row.

If you find this solution helpful, please leave a positive rating!

Jun 22, 2011 | Microsoft Office Excel 2007 Full Version...

2 Answers

How to number a column. I can't remember the short formula, something like a1+1= which would make the number two pop up in the cell underneath.

You can number rows in a column by entering a number in cell A1 (usually the number 1 but youcan start with any number) and the formula (=A1+1) in the next row. The result there will be 2. Copy that formula down the rows you want to number and they will be numbered 3, 4, 5, etc. Each row adds 1 to the previous row so if you do anything that disrupts the sequence (like inserting a row between two others) you will have to copy the formulas down again to restore the sequence. You can also use the Edit-Fill-... menu command to put a series of numbers into rows. Put the starting number in th efirst row. Highlight it and the rows that you want to number and select Edit-Fill-Series... Those numbers will not change if you insert columns or move the formulas.
Or you can use the formula =ROW(A1) in any cell to return the number of that row. (The result of =ROW(A1) is the number 1 in cell A1, the result of =ROW(A2) is the number 2 in cell B2, etc. In this case inserting rows will not affect the numbering (i.e. row A5 will always be numbered 5 even if the data in it is moved down.)

Sep 18, 2009 | Microsoft Excel for PC

1 Answer

Count with 2 or more criteria

Can you do this using a pivot table where columns B & C are Row Fields and Count of B&C is data fields.

Jan 17, 2009 | Microsoft Excel for PC

2 Answers

Display calculation result in a previous cell

Look into the =SUMIF function, it sounds like this may be what you are looking for.

Hope this helps!

Apr 09, 2008 | Microsoft Excel for PC

2 Answers

Should I use countif or if or what ??

hi this my id plz send excel material

Mar 25, 2008 | Microsoft Excel for PC

1 Answer

Excel functions

Here's one way to do it. Your formulas would look like this:

=IF(OR(J1=1, J2=1, J3=1, J4=1, J5=1),1,0)

=IF(OR(J1=2, J2=2, J3=2, J4=2, J5=2),2,0)

=IF(OR(J1=3, J2=3, J3=3, J4=3, J5=3),3,0)


If you don't want the zeroes to display, format the cells with a custom number format--type: 0;-0;;@

Nov 14, 2007 | Business & Productivity Software

1 Answer

Multiple letters in each cell, want to add the letters and tally how many of each

Use the =COUNTIF function

For example if column a has the letters in it:


This will count all of the letter 'a' s in
column a from row 1 to row 100.


Oct 31, 2007 | Microsoft Excel for PC

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

Related Topics:

97 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

18259 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