Subtotal or VLOOKUP?

[aware073]

So this is what my data looks like

2014 Usage 2015 Usage
20000007 20 11
20000007 -1 0
20000007 1 0
20000007 0
20000007 Total

but for a spreadsheet that has about 10,000 items. Is there a formula that will total the 2014 and the 2015 in the "2000007 Total" Row for each item?

 

[aware073]

Just realized how simple this is and finished it. Any tips on how to delete a thread?

 

[mole999]

threads aren't deletable, don't worry about it