use large function with sum criteria

Hi ,

I was doing this task using sorting then adding column today morning one of my friend told i can do it with formula only, no need to using sort and adding new column

I just attached the sheet pls check and let me know is this really possible

See attached.

Thanks Yogi Bro!!!!

@Zobor don't do home work I also dont want to show other person's name Just because easier for understanding, I didnt delete and let it be now If you really know some Idea [B]requesting you to /B]provide for one sample else no need to do homework........................................