Add the similar ID

Hello Everybody
I want to add the similar IDs, for the sake of example workbook is attached with this thread.

You can put this formula in G31:

=SUMIF(F$16:F$26,F31&"*",G$16:G$26)

then copy down.

Hope this helps.

Pete

thanks for your reply, is that also possible with excel vba?

Something like:

Please Login or Register  to view this content.

Hope this helps.

Pete

it works good, but the little problem is that it comes in range(g31) then i have to do it manual, is not it possible that it comes automatic.

It's easy enough to record a simple macro to copy that formula down as far as you need it (in your example it was only 4 rows, but I suspect your real data will be much larger). Then you can examine the code to learn more about the syntax.

Hope this helps.

Pete