Costs in sheet 1 to add up as a total in sheet 2. can this be done?

[jimbo125]

Hi All,
I want the costs in Sheet 1 P15 to P73 that are in line with Committed in the G Column to add up to the total of £1,050,000 in Sheet 2, C 2 under Cost. Can this be done?

Many Thanks,
Jim

Sheet 1			G	H	I	J	K	L	M	N	O	P
		Committed	Order Status	Order	Delivery	Lead	%	Due	Late	Order No	£ Cost
		Approved Etc	Start Date	Date	Time	Done	Over Due
15		Committed	Complete	10/1/19	15/1/19	5	100%				£300,000
21		Committed	~~~			0	0%	43498	LATE		£0
35		Committed	~~~			0	0%	43498	LATE		£140,000
36		Approved	~~~			0	0%	43498	LATE		£25,000
42		Committed	~~~			0	0%	43498	LATE		£200,000
61		Committed	~~~			0	0%	43498	LATE		£400,000
73		Committed	~~~			0	0%	43498	LATE		£10,000
			A	B	C
Sheet 2	1			Count	Cost
2		Committed	7	£1,050,000
3		Approved	4
4		To Be Approved	8
5		Rate / NPO	5

<colgroup><col><col><col><col><col><col><col span="7"><col></colgroup><tbody>
</tbody>

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...t-2-a-post5218675.html?highlight=#post5218675

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).