These are your must haves
How to add a macro in excel
Count values that match my criteria
Finding my values counterpart
Sum values that match my criteria
Add up my values