Sum certain values in a column

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
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