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
[TABLE="width: 797"]
<colgroup><col><col><col><col><col><col><col span="7"><col></colgroup><tbody>[TR]
[TD]Sheet 1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[TD]N[/TD]
[TD]O[/TD]
[TD]P[/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD]Committed[/TD]
[TD]Order Status[/TD]
[TD]Order[/TD]
[TD]Delivery [/TD]
[TD]Lead[/TD]
[TD]%[/TD]
[TD]Due[/TD]
[TD]Late[/TD]
[TD]Order No[/TD]
[TD]£ Cost[/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD]Approved Etc[/TD]
[TD]Start Date[/TD]
[TD]Date[/TD]
[TD]Time[/TD]
[TD]Done[/TD]
[TD]Over Due[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD][/TD]
[TD]Committed[/TD]
[TD]Complete[/TD]
[TD]10/1/19[/TD]
[TD]15/1/19[/TD]
[TD]5[/TD]
[TD]100%[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]£300,000[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD][/TD]
[TD]Committed[/TD]
[TD]~~~[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD]0%[/TD]
[TD]43498[/TD]
[TD]LATE[/TD]
[TD] [/TD]
[TD]£0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]35[/TD]
[TD][/TD]
[TD]Committed[/TD]
[TD]~~~[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD]0%[/TD]
[TD]43498[/TD]
[TD]LATE[/TD]
[TD] [/TD]
[TD]£140,000[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]36[/TD]
[TD][/TD]
[TD]Approved[/TD]
[TD]~~~[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD]0%[/TD]
[TD]43498[/TD]
[TD]LATE[/TD]
[TD] [/TD]
[TD]£25,000[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]42[/TD]
[TD][/TD]
[TD]Committed[/TD]
[TD]~~~[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD]0%[/TD]
[TD]43498[/TD]
[TD]LATE[/TD]
[TD] [/TD]
[TD]£200,000[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]61[/TD]
[TD][/TD]
[TD]Committed[/TD]
[TD]~~~[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD]0%[/TD]
[TD]43498[/TD]
[TD]LATE[/TD]
[TD] [/TD]
[TD]£400,000[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]73[/TD]
[TD][/TD]
[TD]Committed[/TD]
[TD]~~~[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD]0%[/TD]
[TD]43498[/TD]
[TD]LATE[/TD]
[TD] [/TD]
[TD]£10,000[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD][/TD]
[TD="colspan: 7"][/TD]
[/TR]
[TR]
[TD]Sheet 2[/TD]
[TD]1[/TD]
[TD][/TD]
[TD] [/TD]
[TD]Count[/TD]
[TD]Cost[/TD]
[TD][/TD]
[TD="colspan: 7"][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD]Committed[/TD]
[TD]7[/TD]
[TD]£1,050,000[/TD]
[TD][/TD]
[TD="colspan: 7"][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD]Approved[/TD]
[TD]4[/TD]
[TD] [/TD]
[TD][/TD]
[TD="colspan: 7"][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD]To Be Approved[/TD]
[TD]8[/TD]
[TD] [/TD]
[TD][/TD]
[TD="colspan: 7"][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD]Rate / NPO[/TD]
[TD]5[/TD]
[TD] [/TD]
[TD][/TD]
[TD="colspan: 7"][/TD]
[/TR]
</tbody>[/TABLE]

 

[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).