Alternative for COUNTIF. no VBA, no array.

[mescalante48]

Please see the example below, values will keep prompting at irregular intervals;
I need to count each non-zero value, the caveat, no COUNTIF function is allowed, no array functions of VBA neaither.

The reason? I'm working on Sierra chart, (charting software) and array formulas are not supported, please see the below documentation for further details.

Spreadsheet Functions - Sierra Chart

Sierra Chart is a professional Trading platform for the financial markets. Supporting Manual, Automated and Simulated Trading.

www.sierrachart.com

 

[jasonb75]

Unless you can use SUMPRODUCT which doesn't require array confirmation, then you are going to be out of luck. You have already eliminated all of the methods that will do what you need with the specified caveat.

 

[mescalante48]

Unless you can use SUMPRODUCT which doesn't require array confirmation, then you are going to be out of luck. You have already eliminated all of the methods that will do what you need with the specified caveat.

Thank you jasonb75.
SUMPRODUCT is supported, do you know how could it be done using SUMPRODUCT, please?

 

[jasonb75]

It should be as simple as

=SUMPRODUCT(--(range>0))

 

[mescalante48]

It should be as simple as

=SUMPRODUCT(--(range>0))

Almost perfect!!!, see below,
is there anyway we can revert the the order of the count? Eg. 1 on top, then 2,3,4,5...
this because I'll need to perform operations with the first two values only.

Many thanks for your help.

 

[jasonb75]

Try inverting the range, in A1 and fill down.

=SUMPRODUCT(--(A$1:A1>0))

 

[mescalante48]

Solved, below is how it looks.

beyond grateful for your help jasonb75.