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

[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.

 

[Ms-Exl-Learner]

just paste this formula in C1 Cell.

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

If this post helps, Click Yes!

 

[sheryarkhan]

Hi!
you can use sumproduct approach like

=sumproduct(($b:$b=$b1)*($a:$a))

 

[Dave Peterson]

But that formula would only work in xl2007.

(It would work in earlier versions if the entire column were not used.)

 

[Nick Ng]

That did the trick! Thanks everyone.

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