If you're using a previous version of Excel, you can copy the entire Company list and use the "Remove duplicates" tool, or you can enter a formula in A13 and drag it down until it's empty:
=IFERROR(INDEX($C$2:$C$8, MATCH(0,COUNTIF($A$12:A12, $C$2:$C$8), 0)),"")
To get the company name count paste in B13 and drag down:
=COUNTIF($C$2:$C$8,A13)
For "Done" in C13:
=COUNTIFS($C$2:$C$8,A13,$E$2:$E$8,1)&" of "&COUNTIF($C$2:$C$8,A13)
For the sum of numbers in D13:
=SUMIF($C$2:$C$8,A13,$D$2:$D$8)
Result:
