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

Sheet 1			G	H	I	J	K	L	M	N	O	P
		Commited	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%			251452145	£300,000
21		Committed	~~~			0	0%	43498	LATE		£0
35		Committed	~~~			0	0%	43498	LATE		£140,000
36		Committed	~~~			0	0%	43498	LATE		£400,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
	Sheet 2	Budget Data	Count	Cost
	Committed	7
	Approved	4
	To Be Approved	8
	Rate / NPO	5

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

 

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