Making one row of many

Hi Guys

I'm looking for a way to make one row of many others, and summarize only the numbers they contain. My example is the following:

Raw data:

A1: Anything, B1: 2
A2: Something, B2: 6
A3: Something, B3: 1
A4: Nothing, B4: 1

The result I want:

A1: Anything, B1: 2
A2: Something, B2: 7
A3: Nothing, B4: 1

Hi,

If I am getting it correctly....you need the sum of values in colum B if condition matches.

I think Sumif function will be helpful. Please check the attached s/s.

or a pivot table

Thank you Guys! But I was looking for a VBA solution. So I'm going to make a similar post and ask my question more correctly.