Countif and Sum

[goki]

Hi!

when the name changed and sum changed.

[Benjamin2008]

Hi!

when the name changed and sum changed.

To get more responses and correct results, please provide more details ,what you actually need

Thanks

[rwgrietveld]

Put this is F2 and drag down
=SUMIF($A$2:A2,A2,$B$2:B2)

Please read the forum rules. Use titles that describe the problem.

[goki]

To get more responses and correct results, please provide more details ,what you actually need

Thanks

Code A 's sum been C6=9 C10=88
And Code B 's sum been C8=4

Code C ' sum been C9=20 for this result I need help

[goki]

Formula input C2

[goki]

previous Code A refuse sum

[rwgrietveld]

Did you read my solution?

[goki]

Did you read my solution?

Thanks

No good

Put this is F2 and drag down

=if(and(countif(A:A;A2)>0;countif(A3:$A$65536;A2)=0);sumif(A:A;A2;B:B);"")

this is formula problem

I'like Code A 's sum been C6=9 C10=88

[DonkeyOte]

If I've understood... could you not just use:

Please Login or Register  to view this content.

Or, if you need to ensure the total appears only on the last row of each group:

Please Login or Register  to view this content.

(in addition to the above you could consider using Excel's Subtotal functionality which would insert a new row between each group with appropriate totals)

[goki]

Mr.DonkeyOte

Billion thanks for all your support and help. This formula is perfect

Please Login or Register  to view this content.