Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to tally 3 different values in one column?
Is there a way to pull the tally of 3 different values and have the tally
posted to a diffrernt column. Example: One colum has 16 ones 63 twos and 97 threes, but this inforamtion is listed sorted within one column. I do not want to sort, as it will alter my input dates. is there a formula where I can extract the total tally of each indvidual number 1, 2, 3, and have that tally in a different feild? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to tally 3 different values in one column?
Hi
Have a look at COUNTIF or SUMIF. Andy. "Anayray" wrote in message ... Is there a way to pull the tally of 3 different values and have the tally posted to a diffrernt column. Example: One colum has 16 ones 63 twos and 97 threes, but this inforamtion is listed sorted within one column. I do not want to sort, as it will alter my input dates. is there a formula where I can extract the total tally of each indvidual number 1, 2, 3, and have that tally in a different feild? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to tally 3 different values in one column?
Use the SUMIF function. Where A is your range. For 1 =SUMIF($A$1:$A$176,1,$A$1:$A$176) Change the 1 in the formula to sum the other values (2,3) HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=517302 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to tally 3 different values in one column?
Perhaps one of these methods will help:
Try the COUNTIF function. Example: =COUNTIF(A1:A100,2) That counts the number of cells in the range A1:A100 that only contain the number 2. OR You could try a Pivot Table. It would automatically create a table of unique values in your range and display the count of each item. (If you decide to use a Pivot table and need more help, just post your questions) Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Anayray" wrote: Is there a way to pull the tally of 3 different values and have the tally posted to a diffrernt column. Example: One colum has 16 ones 63 twos and 97 threes, but this inforamtion is listed sorted within one column. I do not want to sort, as it will alter my input dates. is there a formula where I can extract the total tally of each indvidual number 1, 2, 3, and have that tally in a different feild? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to tally 3 different values in one column?
Thanks so much! I am quite new to Excel- all is appreciated.
"Ron Coderre" wrote: Perhaps one of these methods will help: Try the COUNTIF function. Example: =COUNTIF(A1:A100,2) That counts the number of cells in the range A1:A100 that only contain the number 2. OR You could try a Pivot Table. It would automatically create a table of unique values in your range and display the count of each item. (If you decide to use a Pivot table and need more help, just post your questions) Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Anayray" wrote: Is there a way to pull the tally of 3 different values and have the tally posted to a diffrernt column. Example: One colum has 16 ones 63 twos and 97 threes, but this inforamtion is listed sorted within one column. I do not want to sort, as it will alter my input dates. is there a formula where I can extract the total tally of each indvidual number 1, 2, 3, and have that tally in a different feild? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
match and count words | Excel Worksheet Functions | |||
Lookup values in a column and display them in order with no gaps | Excel Worksheet Functions | |||
Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions |