For example, in the below sample, only 1 and 8 should sum. The code works when there is a value in E column(For eg when 1 is seen, 2 and 3 will sum. but it is still not working when there are null values until L in the below sample. Hope this helps

E F G H I J K L M N O P 
              5 1       8
1 2 3