Sum certain values in a column

Closed
JB - Feb 24, 2012 at 08:25 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Feb 24, 2012 at 10:02 PM
Hello,

I could use some help with the following formula

Two Columns
1 = Text
2 = Numeral

eg.

AAA - 13
BBB - 6
CCC - 20
BBB - 4

Sum of BBB = 10

I am trying to find a formula to search a Column and Continually increase the sum only of the correct text value

I hope this is clear

Cheers



1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Feb 24, 2012 at 10:02 PM
data is like this with column headings

hdng1 hdng2
AAA 13
BBB 6
CCC 20
BBB 4

in B2 type or copy this formula
=SUMPRODUCT(($A$2:$A$5=A2)*($B$2:$B$5))
copy B2 down
0