Loop and sum in another column if a column value matched

[caooi23]

Hi all,
Attached is a sample data that I would like to loop through column "E", if the value is matched,
then sum the values at "Total..."(G,I,K,M,O,Q,S,U,W), into next column which is "SubTtl1....".
Attached is sample range of data, the numbers of rows will be variable from time to time.

Thanks.

[MarvinP]

Hi,

Try this formula in H2 and pull it down.

=SUMIFS(G$1:G2,E$1:E2,E2)

Is that what you need? If not then give us a correct answer for a few rows in the H and J columns.

[caooi23]

No, it does not help, as it will became duplicate numbers.

[caooi23]

Hi all,
There's no VBA code able to help on this?

[caooi23]

Hi, there's no VBA able to run on sum up the value in this case?

[FDibbins]

Perhaps you missed this in Marvin's post?

Is that what you need? If not then give us a correct answer for a few rows in the H and J columns.

Please provide a few sample answers and explain how you got them
Also, why does this need to be VAB if a formula will give you the answer?

[caooi23]

Hi,
With the sumif, it cumulated the numbers, and for one part number, it will became duplicate total sum.
But I will need only the total sum of the qty(e.g, 8002, total qty is 84249),
the total qty is needed for my next calculation, to analyze what is the changes, if percentage of share change.


PN Item Total Oct SuBTtl1
8002 A1-C 80000 80000
8002 A1-C 4224 84224
8002 A1-C 25 84249