Adding up numbers again

  • Thread starter Thread starter PCOR
  • Start date Start date
P

PCOR

Hi
Need a hand AGAIN
I have the following spreedsheet

A B
1 5
12 10
14 11
14 12
16 2
18 5
19 7
19 12

I want the result to show up 4 or 5 col to right as:

F G
1 5
12 10
14 23
16 2
18 5
19 19
Inother words. Add up the numbers in Col that match in Col A. In this case
if you add the two 14 in col a =23 etc
Thanks
 
One way, assume the number in A starts in A2,
in F2 out this formula entered with ctrl + shift & enter

=INDEX($A$2:$A$40,MATCH(0,COUNTIF($F$1:F1,$A$2:$A$40),0))

(adapt to fit your range)

copy down until you get and error.
In G2 put this formula and copy down

=SUMIF($A$2:$A$40,F2,$B$2:$B$40)
 
Hi Pcor,

Use an advanced filter to create a list of unique items
from the data in col A. Have the new list output set to
col F as in your example. Then, in col G, just use a
simple SUMIF() function.

=SUMIF(A2:A9,E2,B2:B9)

Copy down and adjust references as needed.

Biff
 
Back
Top