Question

In EXCEL VBA:

How would I manage to do this in VBA?

The assignment is in essence add the amount in one column based upon the what’s in one column. In more description:

Column A has a name, column B has random numbers in it, and column C has a price in USD. Some numbers in Column B are the same. For the cells that are the same in column B, I would add together the cells in column C. There are over 550 rows.

Example:

Column B: 100, 100, 54,32

Column C: $1,$3,$50,$18

Requested Output: Totals: $4, $50, $18

Answer 1

You Can use Subtotal Function in the Excel to get the total for the each same value in column B:

It can be done in the following step

1.Raw Data

2.Custom Sort the given data using ColumnB

All Values in Column B are Arranged According to their values

3.Now use Subtotal Function to add the same values in column b and get the subtotal of each same value.

it is in Data Attribute

Now use the sub total on column b and add the values in column c

After selecting subtotal we get the following output

Another Alternative you can try is sumif but not sure that it will work use the below formula not sure it will work

=IF(A2=A1,"",SUMIF(A:A,A2,B:B))