# Count upcoming value to start value

#### aqeelnokia99

##### Board Regular
hi all i need help i want to count reltve cell to upcoming cell vale how much cell have see result colom
 ITEM NO Result I want 66 2 0 34 1 22 2 0 44 2 0 22 2 0 66 4 0 0 0 44 2 0

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

### 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
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
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

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
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

#### majidsiddique

##### Board Regular
Re: how to count upcoming value to start value

Thanks

#### James006

##### Well-known Member
Re: how to count upcoming value to start value

You are welcome ...

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...