Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I need Counting Help
I'm trying to find out if it is possible to enter a series of numbers in a single column, like Column C __________ 1, 4, 5, 7, 9 1, 2, 5, 6, 7, 8, 9 and then construct a series of COUNTIF statements to tally up the numer of times each acceptable value appears in the column. So, for the example above, the results should be: 1 -- 2 2 -- 1 3 -- 0 4 -- 1 5 -- 2 6 -- 1 7 -- 2 8 -- 1 9 -- 2 Is this possible? Thanks! -- Steven Anthony ------------------------------------------------------------------------ Steven Anthony's Profile: http://www.excelforum.com/member.php...o&userid=24153 View this thread: http://www.excelforum.com/showthread...hreadid=377805 |
#2
|
|||
|
|||
How about: column D is 1,2,3,4,5,6,7,8,9 column E = countif($C$1:$C$11,d1) copied down through e9. Is that what you are looking for? -- MrShorty ------------------------------------------------------------------------ MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181 View this thread: http://www.excelforum.com/showthread...hreadid=377805 |
#3
|
|||
|
|||
MrShorty Wrote: How about: column D is 1,2,3,4,5,6,7,8,9 column E = countif($C$1:$C$11,d1) copied down through e9. Is that what you are looking for? I'm not sure--I'm an excel noob (at least to features like this). In my example, the 2 rows under column C represent 2 rows in the spreadsheet. I'll give your suggestion a try (to the extent I understand how to do it!) and see if it works. Thanks! -- Steven Anthony ------------------------------------------------------------------------ Steven Anthony's Profile: http://www.excelforum.com/member.php...o&userid=24153 View this thread: http://www.excelforum.com/showthread...hreadid=377805 |
#4
|
|||
|
|||
When you say, " the 2 rows under column C represent 2 rows in the spreadsheet. ", do you mean that the data are contained in two individual cells in column C, or that column C is the first column, and each number is in its own cell (across to column H)? If it's the latter, it's as simple as moving the formulas around and changing the references. If it's the former, then a simple Data - Text to columns to put the data into columns, then change the references should work. -- MrShorty ------------------------------------------------------------------------ MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181 View this thread: http://www.excelforum.com/showthread...hreadid=377805 |
#5
|
|||
|
|||
MrShorty Wrote: When you say, " the 2 rows under column C represent 2 rows in the spreadsheet. ", do you mean that the data are contained in two individual cells in column C, or that column C is the first column, and each number is in its own cell (across to column H)? If it's the latter, it's as simple as moving the formulas around and changing the references. If it's the former, then a simple Data - Text to columns to put the data into columns, then change the references should work. I was meaning "the latter." And your suggestion works like a charm--as I'm sure you knew it would! Thanks! It really got me out of a jam. -- Steven Anthony ------------------------------------------------------------------------ Steven Anthony's Profile: http://www.excelforum.com/member.php...o&userid=24153 View this thread: http://www.excelforum.com/showthread...hreadid=377805 |
#6
|
|||
|
|||
Glad you got it figured out, and thanks for the feedback. -- MrShorty ------------------------------------------------------------------------ MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181 View this thread: http://www.excelforum.com/showthread...hreadid=377805 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) | |||
Counting... | Excel Worksheet Functions | |||
Counting days worked | Excel Worksheet Functions | |||
counting entries between two dates? | Excel Worksheet Functions |