Need Formula that only show that only the latest positive results and if negative shows zero in latest wk

[Leicester City Fox]

Hi everybody I have a variation on my lasts question posted<o></o>
I need a excel formula that will only select the first batchof positive numbers from only latest week and in this example that’s Week 7 (working backward) and give meresults in highlighted in green (result column)<o></o>
In this example if there a Zero in the latest column it isto record zero and if there a positive number it only start count from there. <o></o>
As the example shown below:


[TABLE="width: 432"]
<colgroup><col width="64" style="width: 48pt;" span="9"> <tbody>[TR]
[TD="width: 64, bgcolor: transparent, align: left"]<v:shapetype id="_x0000_t75" stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" oreferrelative="t" o:spt="75" coordsize="21600,21600"> <v:stroke joinstyle="miter"> <v:formulas> <v:f eqn="if lineDrawn pixelLineWidth 0"> <v:f eqn="sum @0 1 0"> <v:f eqn="sum 0 0 @1"> <v:f eqn="prod @2 1 2"> <v:f eqn="prod @3 21600 pixelWidth"> <v:f eqn="prod @3 21600 pixelHeight"> <v:f eqn="sum @0 0 1"> <v:f eqn="prod @6 1 2"> <v:f eqn="prod @7 21600 pixelWidth"> <v:f eqn="sum @8 21600 0"> <v:f eqn="prod @7 21600 pixelHeight"> <v:f eqn="sum @10 21600 0"> </v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:formulas> <vath o:connecttype="rect" gradientshapeok="t" o:extrusionok="f"> <o:lock aspectratio="t" v:ext="edit"> </o:lock></vath></v:stroke></v:shapetype><v:shape id="Picture_x0020_2" style="width: 432.75pt; height: 90.75pt; margin-top: 0px; margin-left: 0px; visibility: visible; position: absolute; z-index: 1;" type="#_x0000_t75" o:spid="_x0000_s3075" o:gfxdata="UEsDBBQABgAIAAAAIQDcxPXpFQEAAFICAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbKSSy07DMBBF
90j8g+UtSpyyQAgl6YLHEliUDxjsSWIRP2S7Jf17JmkiQVW66cayPb73Ho9drgfTsx2GqJ2t+Cov
OEMrndK2rfjH5iW75ywmsAp6Z7Hie4x8XV9flZu9x8hIbWPFu5T8gxBRdmgg5s6jpUrjgoFEy9AK
D/ILWhS3RXEnpLMJbcrS6MHr8gkb2PaJPQ+0fSBB03D2eDg3RlVcm1E/ZGNFnNQE7OORCLzvtYRE
txM7q47IspkqJ+V0JnbaxxtC/ydhrPyl+h0w696onUErZO8Q0isYYhey1/7TQVBCBfim5sZlssrP
m56gdk2jJSont4a6mM+OC/b5+EQvhGIaL0+ebJZcMf2I+gcAAP//AwBQSwMEFAAGAAgAAAAhAK0w
P/HBAAAAMgEAAAsAAABfcmVscy8ucmVsc4SPzQrCMBCE74LvEPZu03oQkaa9iOBV9AHWZNsG2yRk
49/bm4ugIHibZdhvZur2MY3iRpGtdwqqogRBTntjXa/gdNwt1iA4oTM4ekcKnsTQNvNZfaARU37i
wQYWmeJYwZBS2EjJeqAJufCBXHY6HydM+Yy9DKgv2JNcluVKxk8GNF9MsTcK4t5UII7PkJP/s33X
WU1br68TufQjQpqI97wsIzH2lBTo0Yazx2jeFr9FVeTmIJtafi1tXgAAAP//AwBQSwMEFAAGAAgA
AAAhAFSsDfSMAgAA3wUAAB8AAABjbGlwYm9hcmQvZHJhd2luZ3MvZHJhd2luZzEueG1srFRdb9sg
FH2ftP+AeHf9UbuJraZVZifVpG6r9vEDCCYxGgYLiJtq6n/fBdtJ1EnbtM4vBu7lcO45F65vD61A
PdOGK7nA8UWEEZNU1VzuFvjb13Uwx8hYImsilGQL/MQMvr15++aaFDtNuoZTBAjSFGSBG2u7IgwN
bVhLzIXqmITYVumWWJjqXVhr8gjIrQiTKLoKW8IlvjlBVcQStNf8H6CEot9ZXRLZEwOQghbnKyNH
QV+PTArZ3+nuS/egHXP6sX/QiNcLDMpJ0oJEOBwDYxpMwxe7dieAw1a3Ll9tt+gADiRxDtpg9LTA
eZZkMPRw7GARhXiW5lmeZBhRSIhjyIDJcGDz6fcQtFn9AQRoDnRgcEax49QxlP0Dpy+rvpyqhpjd
a4aSY/nHbNh/D/YYJFXZELljS9MxaoE/bJ6WtFaPDSO1ccuDZE7b4USv3xFvI3i35kI4Um48uqv/
xlyQmVNWKbpvmbRDG2omiIX+Nw3vDEa6YO2GgaP6fR379gTx7411xzkbfIP+SObLKMqTd0GZRWWQ
RrNVsMzTWTCLVrM0SudxGZfPbnecFnvDQAAiqo5PtyVOf2HbcqqVUVt7QVUbDkSnGwNE42i4L6gn
wnXboBEQ8u01UQSlnCSOq9H0M8jsm8NYzSxt3PIWlBvXIfkYGDdOuhrob7R5/KBq6Giyt8oL8Z+a
Fc6akDpt7B1TLXIDkBwI+5NID4oPJU4pjrxUjqAvaar43JQ8ylfz1TwN0uRqBaZUVbBcl2lwtY5n
WXVZlWUVT6Y0vK6ZdHCv98TLrQSvj/Lp3aYUevBq7b/RMHNKC11vnGhMPk5/33LOIv/UwADuEcRe
PG0+e3yK3ft5Pr/5CQAA//8DAFBLAwQUAAYACAAAACEAd1aOndMAAACrAQAAKgAAAGNsaXBib2Fy
ZC9kcmF3aW5ncy9fcmVscy9kcmF3aW5nMS54bWwucmVsc6yQv2oDMQyH90LfwWivdZehlBJfllLI
GpIHELbuzvT8B9stzdtHaZYeBLp0EUhCnz5+2913WNQXl+pTNNDrDhRHm5yPk4HT8f3pBVRtFB0t
KbKBM1fYDY8P2wMv1OSozj5XJZRYDcyt5VfEamcOVHXKHGUzphKoSVsmzGQ/aGLcdN0zlt8MGFZM
tXcGyt5tQB3PWT7/zU7j6C2/JfsZOLY7L7CJFwuQysTNgNa3ya32WlwB72v0/6nhg0Sw0gjsPOHP
vNccxqsGriIeLgAAAP//AwBQSwMEFAAGAAgAAAAhAP3BWu/OBgAAPRwAABoAAABjbGlwYm9hcmQv
dGhlbWUvdGhlbWUxLnhtbOxZT28bRRS/I/EdRntv4/+NozpV7NgNtGmj2C3qcbwe704zu7OaGSf1
DbVHJCREQVyQuHFAQKVW4lI+TaAIitSvwJuZ3fVOvCZJG4EozSHeffub9/+9ebN79dqDiKFDIiTl
ccerXq54iMQ+n9A46Hh3RoNL6x6SCscTzHhMOt6cSO/a5vvvXcUbPqPJmGMxGYUkIggYxXIDd7xQ
qWRjbU36QMbyMk9IDM+mXERYwa0I1iYCH4GAiK3VKpXWWoRp7G0CR6UZ9Rn8i5XUBJ+JoWZDUIwj
kH57OqU+MdjJQVUj5Fz2mECHmHU84DnhRyPyQHmIYangQcermD9vbfPqGt5IFzG1Ym1h3cD8pevS
BZODmpEpgnEutDpotK9s5/wNgKllXL/f7/WrOT8DwL4Pllpdijwbg/VqN+NZANnLZd69SrPScPEF
/vUlndvdbrfZTnWxTA3IXjaW8OuVVmOr5uANyOKbS/hGd6vXazl4A7L41hJ+cKXdarh4AwoZjQ+W
0Dqgg0HKPYdMOdspha8DfL2SwhcoyIY8u7SIKY/VqlyL8H0uBgDQQIYVjZGaJ2SKfcjJHo7GgmIt
AG8QXHhiSb5cImlZSPqCJqrjfZjg2CtAXj3//tXzp+jV8yfHD58dP/zp+NGj44c/Wl7Owh0cB8WF
L7/97M+vP0Z/PP3m5eMvyvGyiP/1h09++fnzciBU0MLCF18++e3Zkxdfffr7d49L4FsCj4vwEY2I
RLfIEdrnEdhmHONqTsbifCtGIabOChwC7xLWfRU6wFtzzMpwXeI6766A5lEGvD677+g6DMVM0RLJ
N8LIAe5yzrpclDrghpZV8PBoFgflwsWsiNvH+LBMdg/HTmj7swS6ZpaUju97IXHU3GM4VjggMVFI
P+MHhJRYd49Sx6+71Bdc8qlC9yjqYlrqkhEdO4m0WLRDI4jLvMxmCLXjm927qMtZmdXb5NBFQkFg
VqL8iDDHjdfxTOGojOUIR6zo8JtYhWVKDufCL+L6UkGkA8I46k+IlGVrbguwtxD0Gxj6VWnYd9k8
cpFC0YMynjcx50XkNj/ohThKyrBDGodF7AfyAFIUoz2uyuC73K0QfQ9xwPHKcN+lxAn36Y3gDg0c
lRYJop/MREksrxPu5O9wzqaYmC4DLd3p1BGN/65tMwp920p417Y73hZsYmXFs3OiWa/C/Qdb9Dae
xXsEqmJ5i3rXod91aO+t79Cravni+/KiFUOX1gOJnbXN5B2tHLynlLGhmjNyU5rZW8IGNBkAUa8z
B0ySH8SSEC51JYMABxcIbNYgwdVHVIXDECcwt1c9zSSQKetAooRLOC8acilvjYfZX9nTZlOfQ2zn
kFjt8okl1zU5O27kbIxWgTnTZoLqmsFZhdWvpEzBttcRVtVKnVla1ahmmqIjLTdZu9icy8HluWlA
zL0Jkw2CeQi83IIjvhYN5x3MyET73cYoC4uJwkWGSIZ4QtIYabuXY1Q1QcpyZckQbYdNBn12PMVr
BWltzfYNpJ0lSEVxjRXisui9SZSyDF5ECbidLEcWF4uTxeio47WbtaaHfJx0vCkcleEySiDqUg+T
mAXwkslXwqb9qcVsqnwRzXZmmFsEVXj7Yf2+ZLDTBxIh1TaWoU0N8yhNARZrSVb/WhPcelEGlHSj
s2lRX4dk+Ne0AD+6oSXTKfFVMdgFivadvU1bKZ8pIobh5AiN2UzsYwi/TlWwZ0IlvPEwHUHfwOs5
7W3zyG3OadEVX4oZnKVjloQ4bbe6RLNKtnDTkHIdzF1BPbCtVHdj3PlNMSV/QaYU0/h/ZoreT+AV
RH2iI+DDu16Bka6UjseFCjl0oSSk/kDA4GB6B2QLvOKFx5BU8GLa/ApyqH9tzVkepqzhJKn2aYAE
hf1IhYKQPWhLJvtOYVZN9y7LkqWMTEYV1JWJVXtMDgkb6R7Y0nu7h0JIddNN0jZgcCfzz71PK2gc
6CGnWG9OJ8v3XlsD//TkY4sZjHL7sBloMv/nKubjwWJXtevN8mzvLRqiHyzGrEZWFSCssBW007J/
TRXOudXajrVkca2ZKQdRXLYYiPlAlMCLJKT/wf5Hhc/sRwy9oY74PvRWBN8vNDNIG8jqS3bwQLpB
WuIYBidLtMmkWVnXpqOT9lq2WV/wpJvLPeFsrdlZ4n1OZ+fDmSvOqcWLdHbqYcfXlrbS1RDZkyUK
pGl2kDGBKfuYtYsTNA6qHQ8+KEGgH8AVfJLygFbTtJqmwRV8Z4JhyX4c6njpRUaB55aSY+oZpZ5h
GhmlkVGaGQWGs/QzTEZpQafSX07gy53+8VD2kQQmuPSjStZUnS9+m38BAAD//wMAUEsDBBQABgAI
AAAAIQAY1OwV4wkAANw3AAAaAAAAY2xpcGJvYXJkL21lZGlhL2ltYWdlMS5lbWbUW29onVcd/iVN
2zSkctdlW8OStukfE7vq7k1iW5m622Ybha0YsooVemFrs63DjpY6m3RWuLAPCg7a6T4omA+STQQp
1OnsvkwCRbcvG4Mi/lkvoqlQ0ULVgYJKfJ4357k5Pb5vzuual+CBX875neec5/ecv/fkpm0xs2Mw
pWqr2aQc5Kc/Y3a+ZLbpwf0PmbXYlV3AW8xWe21YrKNid5vZK+j/FeB++sVnO2zfuysNBLYDtgkG
untaqi3Wg3IJ1lqaeY/dHnPGtodgozC23Vxts06UmTZU1zTLW8Gh+jLEl4BDBlL9/r7q6ibWVrVm
eT1Q9el25bm5Oety5bXI17kyhmN9sHbYZleHtnNpdR3ASzAltfFj+LHT+LLabgAp+yrtgbDTcJaL
g2tFuxUdRXCMQdMJEJP7L1xUL51j5XzaNGKPY98/bYftJH5+kDQ8Mfnbfjtbut1ev9Rv5768zSZ/
158EvgGfiTjT1wa77eUzwxNHW1ueKsPnPmGfC53XW2hXsWGfW9dx+cdoRyNOqWxD/yP/Hp6ovrh7
4uqBPeVPoJ48Zt22H/XiZD22hJWGu23HULe98/bJMR9jfc+3r7Wwbv58gB91C1MyH3M1OLjX2YZG
nznPC+sPgHsa3OOnEte2OYw8Xa7snx/WH4Cdga2AUeMu2O0wYj/oWLv3ZM/avcIY4xGYn3jemA6h
chTrdRwrdsrG7QmU2X4lTJqlX/WMfQw2AmPsZ2BhbGHkyYp9ENjnEPEJ+4JVUOYYGYPGmDTFeh5l
xjoPC2MJyxtrEByLxbrkYl1PiSUsb6whO7t9sVgrsGAc10eRh+MSljfWMG7VxWKNuFjPpMQSljfW
xyNz+LyLdT4llrC8sXZGYl1ysa6nxBKWN9Yu63glaw5PUAcWi+s1hB/heglbBXyxPT+GHf9F+xLO
0LPN/c4+3PdtMGrlvqf1wO6EbYX1wzDE5vkWxrqseKPA9uCIr0EuzhrK5DwCCzmFxTgrduxhnU/y
TjnO6RROYTHOQXvgDz5nw3HOpnAKi3GW7ekzPmcvOnDsW5CHYxcW46zYa4/7nDXHeSSFU1iMc9Cu
HfU5pxzndAqnsBhn2R7e73M2HOdsCqewOOd7nyLnGOwEGvMsFP0m2PeNjR1n1z1qF+493vXui092
7XtpYwcPwjX4CG/EmT/2w/k3wcXbWt4ow2cl+5TWvHAnjW+C3Xd1/OQFtKPpTcA29PUmuHj4pTF+
9pNHbwJx6k1w7dVua4PxTeBjrL8yNHTHfF+QIJ370X+/CViPj1/rRPuff2t4gj7nnvZrTOoO1Ke9
CTjf62GdMLsw2jzTvQCSfY28HxB59A4QxrrF7omyfewA17bJj/I2GGOxL8/5QdjdsO0wYvfB/FjC
qHOxWHttU3LfrUA78tJqMPLyXgp5hcXH8K/fcwzinHKcvJdCTmFxznve8jkbjpP3UsgpLM55+lVy
jsFOoDHnoehzNLlxIHlbt//Nva37BpLFq8JnIs6U9rZmH/9tfeWOjtvCtzXb/L+8rTnf2uf8hUb7
pRdrwT3Iz4dwbYXF1rZiR9/w90vNcfLzIeQUFue8a8TnnHKc/HwIOYXFOe/7q8/ZcJz8fAg5hcU5
L/6MnLo3eA9onsP7KplnNAhj8b4iFos1bH/+PGM1+b247NtcU5Q/DdsKw1cvN91XvQ6LxRqxjZfb
0VacNdfvCPKQU1iMs2KD3/Xnf8pxTqdwCotxDtmffulzNhznbAqnsBhn2Z694XP2ogPnk2ckHLuw
OOdPD/mcNcfJMxJyCotzfv1en3PKcfKMhJzC4pz2d3JqP2fdGw0Xi2cnjCUsFqti+9r9WIudnWT+
0SCMxbNDLB7rzQZjxc5OD9qMwXh2uNfJq3eFsFisB+ypq+HvH+QkX8hZQx2xGGfZurfctNau33QK
J89OPs5/ft/n5Plgv9kUTmFxnY9+0+fsRQdy8uyEYxcW5zw85HPWHCfPTsgpLMY5ZKcO+pxTjpNn
J+QUFuMctNoKcuY5O8k8p8RqOB2xWBX71ZwfqxVxm3s7eCcn848G4bh4dojFYu20yjbGavJ7Y2Rf
fUb0ovwkbAtsAkZMZ0dYLNaD9p33GUucNZTJSe0hp7AYZ8X+OOJzTjnO6RROYXHO9y/7nA3HOZvC
KSzGOWhH/+Fz9qJDMp/Iw7ELi3EO2fHXfc6a4+TZCTmFxTjL9r3XfM4px8mzE3IKi3EOWt9Xfc6G
45xN4RQW4yzbquQ7VZ1HbPeFPRyckWSe0SDUzzNCLB7LRqk/7YysNatvBsbfK/kddB/ydpivq3sB
v4ljA+rJqaS/lfSjgvVtDvjNFe6yBU7WSwsx8bPcBYxaoOumv1F9GD4/41bC/MQ+0kpMZYy3/gj8
ca8xx8ekKs4bU5/dSPL5H/X7Fxy/vFDrlxQvb+yq67wcsevLGHtmGWMnBwTxl2POqy7ocsSuL2Ps
mWWMnXwRukTrrbtsldu/ynTuWa+7jJjuMl4zA/B5l/FuyLq/ADXvLLa7G1aCab/sdD7vVibF9e83
ta26Nr7P8lLcb7yzNR5/zOH9rTaLjfmD3Nnh2G5lTMu5pvx889eUftaaEuO4mXMd5S/Vmob7jWvn
a6OfpY0YtTGnHvlFafskYvja6GdpI0ZtzKlHflHaRhHD10Y/SxsxamNOPczpF6VtHPy+NvpZ2ohR
C3PqkV+ENtAnSdronIalaUsauh+TnkNd7HMrd4HirQSP7t4qyuSWNvpZ2oixLXNqY06fRn+ptdUd
t7TRz9KmtsypRX5R2mYQg9zSRj9LGzG2ZU5tzOkXpY3E5JY2Olna1JY5tcln/yLWtApicksb/Sxt
asucWuSzfxHa6iAmt7TRz9KmtsypRT77F6FtBsTkljb6WdrUljm1yGf/IrSZu9OljX6WNrVlTi3y
i9ImXmnj25JxdReGb0tiVddGfemzvNT3m3iljX7WvKktc2mkJmlcCm1t4BuAdcJWwda78lK8e/V5
A8pkjBoz/edgaetBjCn5IsN9l8H50biXYszhZyH5pa2Kcl5tb***trrjlzb6ebWpb1HzNgMt/rzR
z6tNfYvSxs3ia6OfV5v6FqWtGmijn1eb+halrR5oo59Xm/oWpW0m0EY/rzb1LUqbuTtc55R+Xm3q
W5Q2fnb4Z4F+Xm3qW5Q2feejedsLbUx5PhfUt0htXdDia6OfVxvbFqmNn9m+Nvp5tbFtkdr4fYSv
jX5ebWxbpLbRQBv9vNrYtkht4+D3541+Xm1sW6S2yUAb/bza2HYptbXhVy/F/l/+vsc37Xpo4VuX
Zf19T9p4p/CuzKrf7PrybfoQysOwARj/f9v26vy/WyE/5PFvbPV5WyizTw+sBGOf1uq8Frj2IVgX
C0glGMv/AQAA//8DAFBLAQItABQABgAIAAAAIQDcxPXpFQEAAFICAAATAAAAAAAAAAAAAAAAAAAA
AABbQ29udGVudF9UeXBlc10ueG1sUEsBAi0AFAAGAAgAAAAhAK0wP/HBAAAAMgEAAAsAAAAAAAAA
AAAAAAAARgEAAF9yZWxzLy5yZWxzUEsBAi0AFAAGAAgAAAAhAFSsDfSMAgAA3wUAAB8AAAAAAAAA
AAAAAAAAMAIAAGNsaXBib2FyZC9kcmF3aW5ncy9kcmF3aW5nMS54bWxQSwECLQAUAAYACAAAACEA
d1aOndMAAACrAQAAKgAAAAAAAAAAAAAAAAD5BAAAY2xpcGJvYXJkL2RyYXdpbmdzL19yZWxzL2Ry
YXdpbmcxLnhtbC5yZWxzUEsBAi0AFAAGAAgAAAAhAP3BWu/OBgAAPRwAABoAAAAAAAAAAAAAAAAA
FAYAAGNsaXBib2FyZC90aGVtZS90aGVtZTEueG1sUEsBAi0AFAAGAAgAAAAhABjU7BXjCQAA3DcA
ABoAAAAAAAAAAAAAAAAAGg0AAGNsaXBib2FyZC9tZWRpYS9pbWFnZTEuZW1mUEsFBgAAAAAGAAYA
rwEAADUXAAAAAA==
"> <v:imagedata o:title="" src="file:///C:\Users\hayeg001\AppData\Local\Temp\msohtmlclip1\01\clip_image001.png"> <x:clientdata ObjectType="Pict"> <x:sizewithcells> <x:cf>Bitmap</x:cf> <x:autopict> </x:autopict></x:sizewithcells></x:clientdata> </v:imagedata></v:shape>

<tbody>
[TD="class: xl72, width: 64, bgcolor: transparent"]Proivder[/TD]

</tbody>

[/TD]
[TD="class: xl72, width: 64, bgcolor: transparent"]Week1[/TD]
[TD="class: xl72, width: 64, bgcolor: transparent"]Week2[/TD]
[TD="class: xl72, width: 64, bgcolor: transparent"]Week3[/TD]
[TD="class: xl72, width: 64, bgcolor: transparent"]Week4[/TD]
[TD="class: xl72, width: 64, bgcolor: transparent"]Week5[/TD]
[TD="class: xl72, width: 64, bgcolor: transparent"]Week6[/TD]
[TD="class: xl72, width: 64, bgcolor: transparent"]Week7[/TD]
[TD="class: xl73, width: 64, bgcolor: transparent"]Result[/TD]
[/TR]
[TR]
[TD="class: xl73, bgcolor: transparent"]A[/TD]
[TD="class: xl73, bgcolor: transparent"]1[/TD]
[TD="class: xl73, bgcolor: transparent"]2[/TD]
[TD="class: xl73, bgcolor: transparent"]0[/TD]
[TD="class: xl73, bgcolor: transparent"]1[/TD]
[TD="class: xl73, bgcolor: transparent"]2[/TD]
[TD="class: xl73, bgcolor: transparent"]0[/TD]
[TD="class: xl73, bgcolor: transparent"]0[/TD]
[TD="class: xl75, bgcolor: transparent"]0[/TD]
[/TR]
[TR]
[TD="class: xl73, bgcolor: transparent"]B [/TD]
[TD="class: xl73, bgcolor: transparent"]0[/TD]
[TD="class: xl73, bgcolor: transparent"]0[/TD]
[TD="class: xl73, bgcolor: transparent"]0[/TD]
[TD="class: xl74, bgcolor: transparent"]1[/TD]
[TD="class: xl74, bgcolor: transparent"]1[/TD]
[TD="class: xl74, bgcolor: transparent"]1[/TD]
[TD="class: xl74, bgcolor: transparent"]1[/TD]
[TD="class: xl75, bgcolor: transparent"]4[/TD]
[/TR]
[TR]
[TD="class: xl73, bgcolor: transparent"]C[/TD]
[TD="class: xl73, bgcolor: transparent"]1[/TD]
[TD="class: xl73, bgcolor: transparent"]3[/TD]
[TD="class: xl73, bgcolor: transparent"]0[/TD]
[TD="class: xl73, bgcolor: transparent"]0[/TD]
[TD="class: xl73, bgcolor: transparent"]0[/TD]
[TD="class: xl73, bgcolor: transparent"]0[/TD]
[TD="class: xl74, bgcolor: transparent"]1[/TD]
[TD="class: xl75, bgcolor: transparent"]1[/TD]
[/TR]
[TR]
[TD="class: xl73, bgcolor: transparent"]D[/TD]
[TD="class: xl73, bgcolor: transparent"]0[/TD]
[TD="class: xl73, bgcolor: transparent"]0[/TD]
[TD="class: xl73, bgcolor: transparent"]0[/TD]
[TD="class: xl73, bgcolor: transparent"]0[/TD]
[TD="class: xl73, bgcolor: transparent"]3[/TD]
[TD="class: xl73, bgcolor: transparent"]2[/TD]
[TD="class: xl74, bgcolor: transparent"]1[/TD]
[TD="class: xl75, bgcolor: transparent"]6[/TD]
[/TR]
[TR]
[TD="class: xl73, bgcolor: transparent"]E[/TD]
[TD="class: xl73, bgcolor: transparent"]1[/TD]
[TD="class: xl73, bgcolor: transparent"]1[/TD]
[TD="class: xl73, bgcolor: transparent"]2[/TD]
[TD="class: xl73, bgcolor: transparent"]3[/TD]
[TD="class: xl73, bgcolor: transparent"]0[/TD]
[TD="class: xl73, bgcolor: transparent"]2[/TD]
[TD="class: xl73, bgcolor: transparent"]0[/TD]
[TD="class: xl75, bgcolor: transparent"]0[/TD]
[/TR]
</tbody>[/TABLE]
<v:shapetype id="_x0000_t75" stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" oreferrelative="t" o:spt="75" coordsize="21600,21600"> <v:stroke joinstyle="miter"> <v:formulas> <v:f eqn="if lineDrawn pixelLineWidth 0"> <v:f eqn="sum @0 1 0"> <v:f eqn="sum 0 0 @1"> <v:f eqn="prod @2 1 2"> <v:f eqn="prod @3 21600 pixelWidth"> <v:f eqn="prod @3 21600 pixelHeight"> <v:f eqn="sum @0 0 1"> <v:f eqn="prod @6 1 2"> <v:f eqn="prod @7 21600 pixelWidth"> <v:f eqn="sum @8 21600 0"> <v:f eqn="prod @7 21600 pixelHeight"> <v:f eqn="sum @10 21600 0"> </v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:formulas> <vath o:connecttype="rect" gradientshapeok="t" o:extrusionok="f"> <o:lock aspectratio="t" v:ext="edit"></o:lock></vath></v:stroke></v:shapetype><v:shape id="Picture_x0020_1" style="width: 432.75pt; height: 90.75pt; visibility: visible; mso-wrap-style: square;" type="#_x0000_t75" o:spid="_x0000_i1025"> <v:imagedata o:title="" src="file:///C:\Users\hayeg001\AppData\Local\Temp\msohtmlclip1\01\clip_image001.emz"></v:imagedata></v:shape><o></o>
I only want excel togive the first batch of positive grouped numbers in latest week only (week7) whichare highlighted in red and I need the formula to work out and give the resultsfigures added up shown green.<o></o>
I am great for any help in this area.<o></o>
Many thanks<o></o>
Leicester City Fox J<o></o>
<o> </o>

 

[Joyner]

Hello, there may be an easier way or more logical way, but without too much thought try this:

=IF(H2=0,0,SUM(INDEX(B2:H2,,MATCH(LOOKUP(0.5,B2:H2,$B$1:$H$1),$B$1:$H$1,0)+1):H2))

 

[Leicester City Fox]

Hi Joyner

Many Thanks for this formula it works a treat your a star

Leicester City Fox

 

[Joyner]

Thanks, but maybe no so fast, I see it works fine for your sample data, but if I changes things up a bit, it will not produce the correct results. Let me take another look.

 

[Joyner]

This should be a bit more robust and I think should handle all of your situations:

=IF(H2=0,0,IFERROR(SUM(INDEX(B2:H2,,MATCH(LOOKUP(2,1/(B2:G2=0),$B$1:$G$1),$B$1:$H$1,0)+1):H2),SUM(B2:H2)))

The previous formula would fail if there where no zeros (0), or if there were several blocks for numbers separated by zeros.

 

[Leicester City Fox]

Hi Joyner

You were right I may have shot the gun early.

The amendment works a lot better

Many Thanks

The Leicester City Fox