Formula check

[MiniFav]

I am in the process of making a spreadsheet which help work out some figure for me.

I had a working formula but then had to move some columns around.
I adjusted all the refs within the formula so column D becomes column K, etc.
But now the formula does not give the same answer as it did before.

Would anyyone be able to see what I am doing differently?

COlum J5 and W5 should both come to 3944



EXAMPLE 1: WORKING

ENG_LLP_Template_V1.xlsx
	D	E	F	G	H	I	J
3		THRUST CYCLE LIMITS			CYCLE LIFE USED @
4	a	b	c	a	b	c	a
5	30,000	24,900	20,100	15,220	0	7,260	3944
POPULATE THIS TAB

Cell Formulas
Range	Formula
J4	J4	=D4
J5:J51	J5	=IF(ISNUMBER(D5:D51),IF(ISNUMBER(G5:G51),IFERROR(TEXT(D5:D51*(1-(($G$5:$G$51/$D$5:$D$51)+($H$5:$H$51/$E$5:$E$51)+($I$5:$I$51/$F$5:$F$51))),"#"),""),""),"")
Dynamic array formulas.

EXAMPLE 2: NOT WORKING

ENG LLP Template V2.xlsx
	K	L	M				Q	R	S				W
3		THRUST CYCLE LIMITS						CYCLE LIFE USED @
4	A	B	C				A	B	C				A
5	30,000	24,900	20,100				15,220	0	7,260				0
POPULATE THIS TAB

 

[ExceLoki]

for me both worked :

Book1
	D	E	F	G	H	I	J	K	L	M				Q	R	S				W
3		THRUST CYCLE LIMITS			CYCLE LIFE USED @				THRUST CYCLE LIMITS						CYCLE LIFE USED @
4	a	b	c	a	b	c	a	A	B	C				A	B	C				A
5	30000	24900	20100	15220	0	7260	3944	30000	24900	20100				15220	0	7260				3944
Sheet1

Cell Formulas
Range	Formula
J4	J4	=D4
J5:J51	J5	=IF(ISNUMBER(D5:D51),IF(ISNUMBER(G5:G51),IFERROR(TEXT(D5:D51*(1-(($G$5:$G$51/$D$5:$D$51)+($H$5:$H$51/$E$5:$E$51)+($I$5:$I$51/$F$5:$F$51))),"#"),""),""),"")
W4	W4	=K4
W5:W51	W5	=IF(ISNUMBER(K5:K51),IF(ISNUMBER(Q5:Q51),IFERROR(TEXT(K5:K51*(1-(($Q$5:$Q$51/$K$5:$K$51)+($R$5:$R$51/$L$5:$L$51)+($S$5:$S$51/$M$5:$M$51))),"#"),""),""),"")
Dynamic array formulas.