Hi

I am finding a solution (formula) to automatically sum (3 or 12)
cells
on the right after encountering first right cell greater than 0.

Currently, this is done manually. (eg. 3.9 is the sum of 2.9 (Aug) +
0.5 (Sep) + 0.4 (Oct).)

Question is there a way to do this automatically because there are
thousands of rows..and this will drive me crasy in maintaining this
worksheet effectively. Thanks.

First   First
3M    12M    Jul     Aug   Sep    Oct    Nov
Dec ....................
--------------------------------------------------------------------------------------------------------------------------------------------
3.9     5.4     0.0     2.9     0.5     0.4     0.3
0.2 ....................
1.0     2.2     0.0     0.9     0.0     0.2     0.0
0.4 ....................
0.0     0.0     0.0     0.0     0.0     0.0     0.0
0.0 ....................
3.2     5.2     0.0     0.0     0.0     1.9     1.3
0.9 ....................
3.1     5.1     0.0     0.0     0.0     0.5     1.7
0.9 ....................
2.6     3.9     0.0     0.0     0.0     0.4     1.1
1.1 ....................
.......................
.......................

Ivan

==================================================

The solution to this issue was provided by Roger Govier and Domenic as
follows:
{=SUM(OFFSET(INDEX(2:2,MATCH(TRUE,2:2>0,2:2)),0,0,1,3))} = using CTRL
+ SHIFT + ENTER

It works perfectly. Thank you very much. Cheers!

Ivan
==================================================