Sum up cells in column A that has same text in Column B.

  • Thread starter Thread starter Nick Ng
  • Start date Start date
N

Nick Ng

Hi everyone,

I was wondering if someone could help me out with an Excel problem. Assuming
I have two columns like below:

A B
-- --
22 C1234
12 C5678
8 C9012
10 C5678
51 C5678
63 C1234
87 C1234
14 C9012
etc....

How can I create a formula to automatically sum up those values of column A,
which have similar values in column B. For example, for column B = C1234, the
sum is 172 (22+63+87).

Thanks.
 
just paste this formula in C1 Cell.

=SUMIF($B:$B,$B1,$A:$A)

If this post helps, Click Yes!
 
But that formula would only work in xl2007.

(It would work in earlier versions if the entire column were not used.)
 
That did the trick! Thanks everyone.

Didn't try out your formula, sheryakhan; I'm not good with arrays at all :(
 
Back
Top