VLOOKUP to find sum of all duplicates

For question #1

In F1 place ABC, then use >> =SUMIF(A2:A7,F1,C2:C7)

For question #2
With ABC in F1 and LA in G1 >> =SUMIFS(C2:C7,A2:A7,F1,B2:B7,G1)