Extraction Data in 2 different Sheets & Sum Sales-problem

[loginid]

Dear Friends

I m using Excel 2013 and OS Windows 10

Sheet-1 is the data base. Sheet 2 (i.e. PV)

Formula Required: In Sheet 2 If The month is changed (from May-18 to June-18) then Planned Value (Column D) value should change (i.e. sales sum cumulative)
Also in sheet 2 Total Value (Column E) should change (respect to column M "Gross" of sheet 1) as per Invoice Schedule Revision (Column C of sheet 2) changes (respect to Column K of sheet 1)

Please explain a bit why that particular formula used.

Excel 2013 32 bit

	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]B[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]F[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]G[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]H[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]I[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]J[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]K[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]L[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]M[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]N[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]O[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]P[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Q[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]R[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]S[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]T[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]U[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]V[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]W[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]X[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Y[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Z[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AA[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AB[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AC[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AD[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AE[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AF[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AG[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AH[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AI[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AJ[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AK[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AL[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AM[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AN[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AO[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AP[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AQ[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AR[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AS[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AT[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AU[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AV[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AW[/COLOR]​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]3[/COLOR]​	Project Name​	Revised Contract Value​	Date of LOI​	Contractual Start Date​	Contractual Completion Date​	Revised Completion Date​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]4[/COLOR]​								Date of Rev​	GROSS​	Fy.17 / 18​												Fy. 18 / 19​												Fy. 19 / 20​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]5[/COLOR]​		Rs. In Lacs​				As Actual​				Apr-17​	May-17​	Jun-17​	Jul-17​	Aug-17​	Sep-17​	Oct-17​	Nov-17​	Dec-17​	Jan-18​	Feb-18​	Mar-18​	Apr-18​	May-18​	Jun-18​	Jul-18​	Aug-18​	Sep-18​	Oct-18​	Nov-18​	Dec-18​	Jan-19​	Feb-19​	Mar-19​	Apr-19​	May-19​	Jun-19​	Jul-19​	Aug-19​	Sep-19​	Oct-19​	Nov-19​	Dec-19​	Jan-20​	Feb-20​	Mar-20​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]6[/COLOR]​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]7[/COLOR]​	SUNRAY HOUSING​	292 00​	27-Nov-15​	20-Jul-17​	19-Jul-20​	19-Jul-20​	R0​	Init​	29200​				78​	448​	433​	451​	449​	506​	585​	939​	1257​	1206​	1372​	1278​	1296​	1409​	1498​	1497​	1393​	1507​	1510​	1335​	1170​	1337​	1207​	1103​	938.4​	717.496​	644.897​	634.5​	594.5​	395.71​	11.7314​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]8[/COLOR]​							R1​		0​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]9[/COLOR]​							R2​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]10[/COLOR]​							R3​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]11[/COLOR]​	ISBT-PATNA​	279 51​	02-Dec-16​	22-May-17​	21-Aug-19​	31-Mar-20​	R0​	Init​	28017​				3​	275​	17​	306​	589​	1109​	951​	1512​	2017​	1258​	1477​	1567​	1650​	1932​	1859​	1317​	1577​	1950​	1911​	1475​	1420​	921​	578​	319​	25.49​	0​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]12[/COLOR]​							R1​	Base-line R1​	29098​	0​	0​	0​	271​	11​	28​	320​	598​	403​	463​	747​	1753​	442​	451​	609​	709​	751​	601​	591​	890​	996​	1298​	1379​	1400​	1620​	1689​	1589​	1545​	1413.3​	1266.3​	823​	1021​	1010.5​	979.52​	832.6656​	597.8563​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]13[/COLOR]​							R2​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]14[/COLOR]​	DUMKA​	172 53​	27-Dec-16​	10-Mar-17​	5-Sep-19​	03-Sep-19​	R0​	Init​	21596​	31​	258​	603​	747​	569​	440​	486​	495​	596​	848​	929​	1421​	1162​	1103​	1049​	992​	1027​	1046​	694​	702​	609​	889​	1059​	883​	859​	1041​	1056​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]15[/COLOR]​							R1​	Mar-18​	17295​	0​	124​	184​	189​	287​	331​	290​	395​	406​	236​	423​	647​	520​	561​	817​	1149​	1018​	851​	982​	674​	845​	551​	863​	1103​	483​	415​	601​	1484​	805.529​	59.1179​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]16[/COLOR]​							R2​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]17[/COLOR]​	HAZARIBAGH​	172 73​	27-Dec-16​	10-Mar-17​	9-Sep-19​	27-Jun-19​	R0​	Init​	21596​	31​	258​	603​	747​	569​	440​	486​	495​	596​	848​	929​	1421​	1162​	1103​	1049​	992​	1027​	1046​	694​	702​	609​	889​	1059​	883​	859​	1041​	1056​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]18[/COLOR]​							R1​	Mar-18​	17349​	0​	187​	203​	170​	320​	545​	281​	402​	564​	374​	573​	1294​	580​	659​	872​	906​	791​	767​	882​	814​	548​	532​	656​	1196​	1504​	1079​	648​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]19[/COLOR]​							R2​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]20[/COLOR]​	PALAMU​	170 82​	27-Dec-16​	10-Mar-17​	5-Sep-19​	31-Jul-19​	R0​	Init​	21596​	31​	258​	603​	747​	569​	440​	486​	495​	596​	848​	929​	1421​	1162​	1103​	1049​	992​	1027​	1046​	694​	702​	609​	889​	1059​	883​	859​	1041​	1056​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]21[/COLOR]​							R1​	Mar-18​	16873​	0​	160​	366​	293​	345​	477​	294​	384​	404​	239​	489​	689​	617​	750​	761​	782​	752​	972​	1048​	734​	596​	419​	714​	852​	1663​	1229​	385​	460​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]22[/COLOR]​							R2​

<tbody>
</tbody>

Sheet: Sheet1

<tbody>
</tbody>

Excel 2013 32 bit

	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]A[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]B[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]C[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]D[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]E[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]F[/COLOR]​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]2[/COLOR]​		Month​	Extraction Data in 2 different Sheets & Sum Sales-problem
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]3[/COLOR]​		May-18​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]4[/COLOR]​				Value changes with month change	Value changes with Invoice Schedule Revision change
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]5[/COLOR]​	S no.	PROJECTS	Invoice Schedule Revision	Planned Value (Lacs)	Total Value (Lacs)	Planned %
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]6[/COLOR]​	1​	ISBT-PATNA	=Sheet1!R[6]C[8]	=SUM(Sheet1!R[6]C[10]:R[6]C[23])​	=Sheet1!R[6]C[8]​	=RC[-2]/RC[-1]​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]7[/COLOR]​	2​	SUNRAY HOUSING	=Sheet1!RC[8]	=SUM(Sheet1!RC[10]:RC[23])​	=Sheet1!RC[8]​	=RC[-2]/RC[-1]​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]8[/COLOR]​	3​	DUMKA	=Sheet1!R[7]C[8]	=SUM(Sheet1!R[7]C[10]:R[7]C[23])​	=Sheet1!R[7]C[8]​	=RC[-2]/RC[-1]​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]9[/COLOR]​	4​	HAZARIBAGH	=Sheet1!R[9]C[8]	=SUM(Sheet1!R[9]C[10]:R[9]C[23])​	=Sheet1!R[9]C[8]​	=RC[-2]/RC[-1]​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]10[/COLOR]​	5​	PALAMU	=Sheet1!R[11]C[8]	=SUM(Sheet1!R[11]C[10]:R[11]C[23])​	=Sheet1!R[11]C[8]​	=RC[-2]/RC[-1]​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]11[/COLOR]​	6​	BELLEVUE-NC	=Sheet1!R[13]C[8]	=SUM(Sheet1!R[13]C[10]:R[13]C[23])​	=Sheet1!R[13]C[8]​	=RC[-2]/RC[-1]​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]12[/COLOR]​	7​	CIVIC TOWER	=Sheet1!R[14]C[8]	=SUM(Sheet1!R[14]C[10]:R[14]C[23])​	=Sheet1!R[14]C[8]​	=RC[-2]/RC[-1]​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]13[/COLOR]​	8​	GUWAHATI AIRPORT	=Sheet1!R[16]C[8]	=SUM(Sheet1!R[16]C[10]:R[16]C[23])​	=Sheet1!R[16]C[8]​	=RC[-2]/RC[-1]​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]14[/COLOR]​	9​	SIVASAGAR HOSPITAL	=Sheet1!R[18]C[8]	=SUM(Sheet1!R[18]C[10]:R[18]C[23])​	=Sheet1!R[18]C[8]​	=RC[-2]/RC[-1]​

<tbody>
</tbody>

Sheet: PV

<tbody>
</tbody>

Thank u.