formula from sheet 1 to sheet 2

[jimbo125]

Hi All,
In sheet 1 i have everything sorted but i want to add the COST for everything COMMITTED into Sheet 2.
Can anyone please help me.

Many Thanks,
Jim


[TABLE="width: 773"]
<colgroup><col><col><col><col><col span="9"></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]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD]Commited[/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]
[/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]
[/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]251452145[/TD]
[TD]£300,000[/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]
[/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]
[/TR]
[TR]
[TD]36[/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]
[/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]
[/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]
[/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]
[/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]
[/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]
[/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]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]Sheet 2[/TD]
[TD]Budget Data[/TD]
[TD]Count[/TD]
[TD]Cost[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Committed[/TD]
[TD]7[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Approved[/TD]
[TD]4[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]To Be Approved[/TD]
[TD]8[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Rate / NPO[/TD]
[TD]5[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[jtakw]

Hi,

Change adjust Cell references/Range, Add Sheet Name, as needed.

For my sample, C18 formula copied down:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1				Sheet 1
2						Commited	Order Status	Order	Delivery	Lead	%	Due	Late	Order No	£ Cost
3						Approved Etc	Start Date	Date	Time	Done	Over Due
4				15		Committed	Complete	1/10/2019	1/15/2019	5	100%			251452145	$300,000
5				21		Committed	~~~			0	0%	2/2/2019	LATE		$0
6				35		Committed	~~~			0	0%	2/2/2019	LATE		$140,000
7				36		Committed	~~~			0	0%	2/2/2019	LATE		$400,000
8				42		Committed	~~~			0	0%	2/2/2019	LATE		$200,000
9				61		Committed	~~~			0	0%	2/2/2019	LATE		$400,000
10				73		Committed	~~~			0	0%	2/2/2019	LATE		$10,000
11						To Be Approved									$99,999
12						Rate / NPO									$199,999
13						Approved									$299,999
14
15
16	Sheet 2
17	Budget Data	Count	Cost
18	Committed	7	$1,450,000
19	Approved	4	$299,999
20	To Be Approved	8	$99,999
21	Rate / NPO	5	$199,999
Sheet528

Cell Formulas
Range	Formula
C18	=SUMIF(F$4:F$13,A18,O$4:O$13)

 

[jimbo125]

Thanks bud, I will give it a try.

Cheers,
Jim

 

[jtakw]

You're welcome.

 

[jimbo125]

Worked a treat, great forum this.

Thanks,
Jim

 

[jtakw]

Glad it worked for you.