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

Hi!
you can use sumproduct approach like

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


"Ms-Exl-Learner" wrote:

just paste this formula in C1 Cell.

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

If this post helps, Click Yes!

--------------------
(MS-Exl-Learner)
--------------------



"Nick Ng" wrote:

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.

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

But that formula would only work in xl2007.

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

sheryarkhan wrote:

Hi!
you can use sumproduct approach like

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

"Ms-Exl-Learner" wrote:

just paste this formula in C1 Cell.

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

If this post helps, Click Yes!

--------------------
(MS-Exl-Learner)
--------------------



"Nick Ng" wrote:

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.



--

Dave Peterson