help with modifying sumif

[BrutalLogiC]

help I'm trying to write a dynamic formula to produce a result which will change depending on what value I enter in cell B3...

My current formula is:
=SUMIF('Revenue Register'!D:D,G7,'Revenue Register'!M:M)*-1-(SUMIF('Cost Register'!D:D,G7,'Cost Register'!M:M))

but I want to somehow link it to cell B3 so that if I enter a posting period number into B3 it looks at the corresponding data in the revenue and cost sheets.

so if put 8 in cell B3 then the calculation would be the equivalent of (732,940)*-1 minus 486,839 which is 246,061 which is the equivalent of changing the original formula to
=SUMIF('Revenue Register'!D:D,G7,'Revenue Register'!L:L)*-1-(SUMIF('Cost Register'!D:D,G7,'Cost Register'!L:L))

it is to save me manually changing the formula to check different periods..

09.2020 TFM.xlsb
	B					G
2	Posting period:
3	9
4
5	$					Project
6
7	258,101					Project A
8	187,514					Project B
9	176,932					Project C
10	168,680					Project D
11	268,482					Project E
12	136,456					Project F
13	305,197					Project G
Actual vs. Budget

09.2020 TFM.xlsb
	D	E	F	G	H	I	J	K	L	M	N	O	P
4		Revenue Posting period:
5	Project	1	2	3	4	5	6	7	8	9	10	11	12
6	Project A	(732,940)	(732,940)	(732,940)	(732,940)	(732,940)	(732,940)	(732,940)	(732,940)	(732,940)
7	Project B	(447,427)	(447,427)	(447,427)	(460,077)	(447,427)	(447,427)	(447,427)	(447,427)	(447,427)
8	Project C	(263,253)	(263,253)	(263,253)	(264,058)	(263,253)	(263,253)	(263,253)	(263,253)	(263,253)
9	Project D	(222,999)	(222,999)	(222,999)	(222,999)	(222,999)	(222,999)	(222,999)	(222,999)	(222,999)
10	Project E	(621,788)	(621,788)	(621,788)	(621,788)	(653,988)	(621,788)	(621,788)	(598,455)	(598,455)
11	Project F	(382,875)	(432,555)	(384,945)	(459,580)	(380,808)	(491,929)	(380,805)	(386,225)	(380,805)
12	Project G	(491,844)	(491,844)	(499,434)	(493,914)	(491,843)	(491,844)	(491,844)	(491,844)	(491,844)
Revenue Register

09.2020 TFM.xlsb
	D	E	F	G	H	I	J	K	L	M	N	O	P
4		Cost Posting period:
5	Project	1	2	3	4	5	6	7	8	9	10	11	12
6	Project A	391,350	476,717	642,750	467,143	531,403	574,002	525,788	486,879	474,839
7	Project B	248,577	260,975	273,827	285,520	271,126	270,538	218,642	252,268	259,912
8	Project C	77,799	134,698	82,028	104,212	67,417	85,419	82,115	77,681	86,320
9	Project D	107,822	86,010	20,850	58,100	31,997	40,688	61,103	37,279	54,319
10	Project E	285,127	286,458	276,404	281,219	291,462	342,540	340,543	358,532	329,973
11	Project F	341,037	342,597	229,907	291,338	97,491	289,765	206,368	269,573	244,349
12	Project G	163,056	229,932	234,013	230,680	235,537	219,402	189,763	204,338	186,647
Cost Register

 

[Fluff]

How about

=SUMIF('Revenue Register'!D:D,G7,INDEX('Revenue Register'!$E:$S,,$B$3))*-1-(SUMIF('Cost Register'!D:D,G7,INDEX('Cost Register'!$E:$S,,$B$3)))

 

[BrutalLogiC]

How about

=SUMIF('Revenue Register'!D:D,G7,INDEX('Revenue Register'!$E:$S,,$B$3))*-1-(SUMIF('Cost Register'!D:D,G7,INDEX('Cost Register'!$E:$S,,$B$3)))

excellent thanks that works!

 

[Fluff]

You're welcome & thanks for the feedback.