Count upcoming value to start value

aqeelnokia99

Board Regular
Joined
Dec 23, 2018
Messages
65
hi all i need help i want to count reltve cell to upcoming cell vale how much cell have see result colom
ITEM NOResult I want
662
0
341
222
0
442
0
222
0
664
0
0
0
442
0

<colgroup><col><col></colgroup><tbody>
</tbody>
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

aqeelnokia99

Board Regular
Joined
Dec 23, 2018
Messages
65
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

Well-known Member
Joined
Apr 4, 2009
Messages
3,680
Re: how to count upcoming value to start value

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

You can have in cell B2 :

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

majidsiddique

Board Regular
Joined
Oct 22, 2018
Messages
164

ADVERTISEMENT

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

Well-known Member
Joined
Apr 4, 2009
Messages
3,680
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 :

Code:
=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
 

James006

Well-known Member
Joined
Apr 4, 2009
Messages
3,680
Re: how to count upcoming value to start value

You are welcome ...
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,417
Messages
5,511,233
Members
408,831
Latest member
heidiussel

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top