Question about Microsoft Excel for PC

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

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

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

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 http://ginstrom.com/CountAnything/

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.

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

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!

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

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

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

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

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

Hope this helps!

Hope this helps!

Apr 09, 2008 | Microsoft Excel for PC

hi this my id :dadu_mf@rediff.com plz send excel material

Mar 25, 2008 | Microsoft Excel for PC

Read:

http://www.improveyourexcel.com/excel/Counting.cfm

specif:

http://www.exceltip.com/show_tip/Counting/Count_how_many_numbers_are_in_series_of_numbers_when_a_certain_criteria_is_set_in_Microsoft_Excel

http://www.exceltip.com/st/COUNT_Formulas/168.html

That should take you there.

http://www.improveyourexcel.com/excel/Counting.cfm

specif:

http://www.exceltip.com/show_tip/Counting/Count_how_many_numbers_are_in_series_of_numbers_when_a_certain_criteria_is_set_in_Microsoft_Excel

http://www.exceltip.com/st/COUNT_Formulas/168.html

That should take you there.

Mar 16, 2008 | Microsoft Excel for PC

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

B1:

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

B2:

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

B3:

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

etc.

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

B1:

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

B2:

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

B3:

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

etc.

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

Use the =COUNTIF function

For example if column a has the letters in it:

=COUNTIF(a1:a100,"a")

or

@COUNTIF(a1..a100,"a")

This will count all of the letter 'a' s in

column a from row 1 to row 100.

Mike

For example if column a has the letters in it:

=COUNTIF(a1:a100,"a")

or

@COUNTIF(a1..a100,"a")

This will count all of the letter 'a' s in

column a from row 1 to row 100.

Mike

Oct 31, 2007 | Microsoft Excel for PC

Jan 28, 2016 | Microsoft Excel for PC

97 people viewed this question

Usually answered in minutes!

COUNTIF(insert cell range,1)

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.

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.

did you fix your problem?

×