Create Totals (sum from Type of Expense (column data)

[agjwilson]

I have spent a lot of time making a great spreadsheet in Excel 2016. With relative ease and understanding for my business costs on one page. I would really appreciate it (my first time asking in this forum) if someone could help me create a formula that would give me totals for my Type of Expenses in the Column (it is located just under the Bold text of Year 2015)


[TABLE="width: 198"]
<colgroup>

</colgroup><tbody>[TR]
[TD]

• Cost of Sales - Goods

[/TD]
[/TR]
[TR]
[TD]

• Cost of Sales - Materials

[/TD]
[/TR]
[TR]
[TD]

• Cost of Sales - Hire

[/TD]
[/TR]
[TR]
[TD]

• Marketing Costs

[/TD]
[/TR]
[TR]
[TD]

• Insurance Costs

[/TD]
[/TR]
[TR]
[TD]

• Motor Fuel

[/TD]
[/TR]
[TR]
[TD]

• Motor Maintenance

[/TD]
[/TR]
[TR]
[TD]

• Office Costs

[/TD]
[/TR]
[TR]
[TD]

• Staff Clothing

[/TD]
[/TR]
[TR]
[TD]

• Meeting Costs

[/TD]
[/TR]
[TR]
[TD]

• Office Labour

[/TD]
[/TR]
[TR]
[TD]

• Refund

[/TD]
[/TR]
[TR]
[TD]

• Travel

[/TD]
[/TR]
</tbody>[/TABLE]

As you can see I have the usual list of expenses and each entry in the spreadsheet is associated to a 'type of expense'
Now I should have done this earlier I know however I would like to have a total for each 'type of expense' so I can see the total costs in each 'type of expense'.

I hope this is an understandable question. I may need to reword it.

 

[AlanY]

can try the sumif() function like this

Excel 2012
	A	B	C	D	E
1	Total	Type of expense		Type of expense	Total
2	10	Cost of Sales - Goods		Cost of Sales - Goods	20
3	10	Cost of Sales - Goods		Cost of Sales - Hire	50
4	10	Cost of Sales - Hire		Cost of Sales - Materials	10
5	10	Cost of Sales - Materials
6	10	Cost of Sales - Hire
7	10	Cost of Sales - Hire
8	10	Cost of Sales - Hire
9	10	Cost of Sales - Hire
Sheet4

Cell Formulas
Range	Formula
E2	=SUMIF($B$2:$B$9,$D2,$A$2:$A$9)

 

[agjwilson]

Alan Y,

Thank you for helping me sort that out. I've not input a very similar table onto one of my worksheets and its added all the totals up corresponding to 'types of expenses'.

Regards,
Alex

 

[agjwilson]

I meant to write "I've now input"
Typo made it sound very odd !

 

[AlanY]

glad that help