Count upcoming value to start value

[aqeelnokia99]

hi all i need help i want to count reltve cell to upcoming cell vale how much cell have see result colom
[TABLE="width: 214"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD="align: center"]ITEM NO[/TD]
[TD="align: center"]Result I want[/TD]
[/TR]
[TR]
[TD="align: center"]66[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD="align: center"]0[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]34[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD="align: center"]22[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD="align: center"]0[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]44[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD="align: center"]0[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]22[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD="align: center"]0[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]66[/TD]
[TD="align: center"]4[/TD]
[/TR]
[TR]
[TD="align: center"]0[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]0[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]0[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]44[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD="align: center"]0[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[James006]

Re: how to count upcoming value to start value

Hello,

This question is very similar to your previous question ...

https://www.mrexcel.com/forum/excel...upcoming-row-0-a-post5199976.html#post5199976

If I am not mistaken ... you could easily use the Offset portion to achieve your objective ...

 

[aqeelnokia99]

Re: how to count upcoming value to start value

Yes its similar but i try to make another formula above link that u send me becuse i set 2 formula and if both formula give me same result then i send my data to oracel form so thats y i need count result to make second result

 

[James006]

Re: how to count upcoming value to start value

Now that you know what an Array Formula is ...

You can have in cell B2 :

=IF(A2=0,"",MATCH(TRUE,(A3:$A$16)>0,0))

HTH

 

[majidsiddique]

Re: how to count upcoming value to start value

Hi James006,
this formula is not working in last qty count. could you please tell me any error in it?
in A15 count 2 but not working.
Thanks.

 

[James006]

Re: how to count upcoming value to start value

Hello,

The last value is not calculated because there is no integer in cell A17 ...

Below is a quick fix :

=IFERROR(IF(A2=0,"",MATCH(TRUE,(A3:$A$16)>0,0)),SUMPRODUCT(MAX((ROW($A$1:$A$50))*($A$1:$A$50<>"")))-ROW()+1)

HTH

 

[majidsiddique]

Re: how to count upcoming value to start value

Thanks

 

[James006]

Re: how to count upcoming value to start value

You are welcome ...