A B C D
1 48'' 22.0 48 66.0
2 48'' 22.0 45 61.8
3 48'' 22.0
4 45'' 20.6
5 45'' 20.6
6 45'' 20.6
7 0'' 0.0
8 0'' 0.0
9 0'' 0.0

In the above A1:B9 are inputs. I desire these outputs in C1:D9 using ONLY formulas in C1:D9, no macros.

Its a summary table I need. C columnn acts as a descriptor, D are sums of matching descriptiors

THANKS!