software

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?

Hi

Have a look at COUNTIF or SUMIF.

Andy.

quot;Anayrayquot; gt; wrote in message
...
gt; Is there a way to pull the tally of 3 different values and have the tally
gt; posted to a diffrernt column. Example: One colum has 16 ones 63 twos and
gt; 97
gt; threes, but this inforamtion is listed sorted within one column. I do not
gt; want to sort, as it will alter my input dates. is there a formula where I
gt; can
gt; extract the total tally of each indvidual number 1, 2, 3, and have that
gt; tally
gt; in a different feild?

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)

HTHSteve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=517302Perhaps 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-Proquot;Anayrayquot; wrote:

gt; Is there a way to pull the tally of 3 different values and have the tally
gt; posted to a diffrernt column. Example: One colum has 16 ones 63 twos and 97
gt; threes, but this inforamtion is listed sorted within one column. I do not
gt; want to sort, as it will alter my input dates. is there a formula where I can
gt; extract the total tally of each indvidual number 1, 2, 3, and have that tally
gt; in a different feild?

Thanks so much! I am quite new to Excel- all is appreciated.

quot;Ron Coderrequot; wrote:

gt; Perhaps one of these methods will help:
gt;
gt; Try the COUNTIF function.
gt; Example: =COUNTIF(A1:A100,2)
gt; That counts the number of cells in the range A1:A100 that only contain the
gt; number 2.
gt;
gt; OR
gt; You could try a Pivot Table. It would automatically create a table of
gt; unique values in your range and display the count of each item.
gt; (If you decide to use a Pivot table and need more help, just post your
gt; questions)
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;Anayrayquot; wrote:
gt;
gt; gt; Is there a way to pull the tally of 3 different values and have the tally
gt; gt; posted to a diffrernt column. Example: One colum has 16 ones 63 twos and 97
gt; gt; threes, but this inforamtion is listed sorted within one column. I do not
gt; gt; want to sort, as it will alter my input dates. is there a formula where I can
gt; gt; extract the total tally of each indvidual number 1, 2, 3, and have that tally
gt; gt; in a different feild?