Help in SUMIF Formula

[PRIMA]

Hello Everyone,

Can anybody please help in the attached image below:

I want to get the actual result in Column H when adding the Column I.

Many thanks

 

[Aladin Akyurek]

The data in the images cannot be read into Excel, unless the people who are trying to help retype it for experimenting, formula building, etc.

 

[PRIMA]

The result should look like in Column J:

Many thanks

 

[PRIMA]

Hi Aladin,

Sorry, I do not know how to attach the file. If you don't mind, can you help how to that? Thank you so much.

 

[PRIMA]

The data in the images cannot be read into Excel, unless the people who are trying to help retype it for experimenting, formula building, etc.

Hi Aladin,

Sorry, I do not know how to attach the file. If you don't mind, can you help how to that? Thank you so much.

 

[Aladin Akyurek]

Hi Aladin,

Sorry, I do not know how to attach the file. If you don't mind, can you help how to that? Thank you so much.

https://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729

 

[PRIMA]

Excel Workbook
	A	B	C	D	E	F	G	H	I	J
1										ACTUAL RESULT
2	WBS					ACT ID	ACT NAME	TOTAL COST	ACTUAL COST	TOTAL COST
3	PROJECT BL							4,515,246.00		3,987,296.00
4		GENERAL						4,510,246.00		3,982,296.00
5			MILESTONE					710,000.00		585,000.00
6						GEN-P09-1000	Commencement Date	125,000.00
7						GEN-P09-1630	Completion Date	585,000.00	585,000.00	585,000.00
8			CONTRACTUAL REQUIREMENTS					3,800,246.00		3,397,296.00
9						GEN-P09-1040	Performance bond	498,750.00	498,750.00	498,750.00
10						GEN-P09-1050	Insurance of work	23,750.00	23,750.00	23,750.00
11						GEN-P09-1060	Third party insurance	23,750.00
12						GEN-P09-1070	Workmen compensation insurance	47,500.00	47,500.00	47,500.00
13				PRELIMINARIES				1,874,600.00		1,854,500.00
14						GEN-P09-1100	All obligations and Liabilities in complying with the General & Particular of the Contracts	47,500.00	47,500.00	47,500.00
15						GEN-P09-1110	Providing all necessary superintendence in accordance with the General Conditions of the Contract	850,000.00	850,000.00	850,000.00
16						GEN-P09-1120	Quality Assurance Including Testing of Materials and Work	925,000.00	925,000.00	925,000.00
17						GEN-P09-1130	Contractual Requirements on temporary controls on the environment and coordination	32,000.00	32,000.00	32,000.00
18						GEN-P09-1140	Specified Requirements excluding temporary works, mobilization/demobilization	20,100.00
19				PERMITS & APPROVALS				1,331,896.00		972,796.00
20					PROJECT SIGN BOARD			421,796.00		421,796.00
21						GEN-P09-1080	Apply for Signboard permit	268,900.00	268,900.00	268,900.00
22						GEN-P09-1230	Approve Signboard permit	152,896.00	152,896.00	152,896.00
23					TEMPORARY OFFICE PERMIT			732,000.00		482,000.00
24						GEN-P09-1090	Apply Site office permit	120,000.00	120,000.00	120,000.00
25						GEN-P09-1180	Apply for Environmental permit	250,000.00
26						GEN-P09-1190	Apply for Excavation permit	362,000.00	362,000.00	362,000.00
27					HOARDING, SIGNBOARD & ACCESS ROAD			178,100.00		69,000.00
28						GEN-P09-1310	Submit drawing for signboard	6,000.00	6,000.00	6,000.00
29						GEN-P09-1320	Installation of fence & Security Post	109,100.00
30						GEN-P09-1330	Access Road Installation to Project Office	63,000.00	63,000.00	63,000.00
31		DESIGN & ENGINEERING						5,000.00		5,000.00
32			SHOP DRAWING					5,000.00		5,000.00
33						ENG-SP-P09-1000	Prepare & Submit Baseline programme	2,500.00	2,500.00	2,500.00
34						ENG-SP-P09-1010	Review & Approve Baseline programme	2,500.00	2,500.00	2,500.00
Sheet1