Whats the formula for....

[VanessaMA]

Hi,

Anyone remembers or knows what the formula is to GROUP same values in different lines same column (ex column A) and then add the values they have in the column next to it (example column B)

To describe better:

A B
HelloWorld 10
HelloWorld 56
HelloWorld 96
HelloWorld 22
GoodbyeW 10
HelloWorld 15

So basically what I want is that the formula is able to detect all the "HelloWorld" and give me the total sum which is 199

Thanks!
Vanessa

[Richard Buttrey]

Hi,

In C1 copied down
=SUMIF(A1:A6,A1,B1:B6)

It would be more normal to first extract a unique list of the column A values in a new column (say E) and use the formula above against that list

i.e.
In E1 and copied to E2
=SUMIF(A1:A6,E1,B1:B6)

[VanessaMA]

IT works, the only problem is that it still gives me a value next to the second "helloworld". I think there is an option to just put a "0" if a value has already been assigned to that reference. Because if it puts values in every single reference, it is hard to distinguish which one is the real sum and which one is it. Not sure if I am making any sense.

[Ursul]

Hi,

If cell A1 did not contain the word "HelloWorld" then the formula would need to be adjusted to read:

=SUMIF(A1:A6,"HelloWorld",B1:B6)

Cheers,