How can I find sum of similar numbers in one column?
Posted by P. P. Ervo on August 29, 2001 3:24 AM
SO, I have column like this:
2650
2500
2650
2500
2800
2650
2800
2800
2800
2650
2800
2800
2800
2650
2800
2800
Now, how can I find easily total quantity of each number? Yep, that is only a sample, the real table is much more longer..
Posted by Gianni on August 29, 2001 3:33 AM
One way would be to sort and then sub-total
Posted by RobJackson on August 29, 2001 3:59 AM
Use the SUMIF function
Posted by Rob Jackson on August 29, 2001 4:00 AM
Or the COUNTIF function if you want the number rather than the total.
Posted by Curious on August 29, 2001 4:23 AM
How?
Posted by Aladin Akyurek on August 29, 2001 5:19 AM
You can make a list of unique numbers, say in B from B2 on. Then, in order to count occurrences of each unique number,
in C2 enter: =COUNTIF($A$2:$A$25,B2) [ copy down as far as needed ]
Substitute SUMIF for COUNTIF in the above formula if you want a total per unique number or just enter =COUNTIF($A$2:$A$25,B2)*B2
Note 1. The above would be in accord with Rob's suggested line.
Note 2. You can create the unique list with filtering, although this can also be done by means of formulas.
Aladin
==============
Posted by Rob Jackson on August 29, 2001 5:42 AM
Re: How?
OK, say your target range is A1 to A100. Use the formula:
=SUMIF(A1:A100,whichvalue,A1:A100)
you can use another cell to define the 'whichvalue' or simply put it in the formula.
Rob
Posted by Curious on August 29, 2001 6:03 AM
Re: How?
Hmmm .... was actually enquiring about how you would find out what all the values were to be summed, but I see Aladin has suggested a way.
(Also, Gianni's suggestion looks good).
Posted by Mark W. on August 29, 2001 7:17 AM
I'd use a PivotTable (NT)
