Column addition

I have an excel sheet with about 44000 entries of yearly company sales data. I am trying to get total of sales of a particular company, for a specific year. For example, my data looks like table A and i want to make it look like table B. What formulas

Table A

Year Sales Company number
2001 2345 7896
2001 1234 7896
2001 2144 7896
2001 2338 9440
2001 4340 9440
2001 2316 9440
2002 2330 7896
2002 4679 7896
2002 4873 7896
2002 2495 9440


Table B

Year Sales Company number
2001 5723 7896
2001 8994 9440
2002 11882 7896
2002 2495 9440

Sometimes they are fewer or more, there are not always the same number of observations

You can do this pretty easily with a Pivot Table.

Try this:

Highlight your data (A1:C11 in your example) > Insert > PivotTable > Drag "Year" and "Company Number" into Rows (with "Year" on top) > Drag "Sales" into Values

I would normally use SUMIFS() for this type of work, but if you like the Pivot Table go with that. I have added to your sheet the SUMIFS formulation.