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:

<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> Proivder <tbody> </tbody>	Week1	Week2	Week3	Week4	Week5	Week6	Week7	Result
A	1	2	0	1	2	0	0	0
B	0	0	0	1	1	1	1	4
C	1	3	0	0	0	0	1	1
D	0	0	0	0	3	2	1	6
E	1	1	2	3	0	2	0	0

<colgroup><col width="64" style="width: 48pt;" span="9"> <tbody> </tbody>

<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