If you want the first non-zero value then copy this in B1
=INDIRECT("A"&MATCH(1,(IF(A1:A10000,1,"")),0))
and press CTRL-SHIFT-ENTER

"Oligo" wrote:



"Sheeloo" wrote:

If you are sure that all others are zero then you can simply have this in B1
=Sum(A1:A100) [change 100 to the last cell in Col A]

"Oligo" wrote:

A
0.00000000
0.00000000
0.00000000
0.00000000
0.00000000
0.00000000
0.00000000
0.00000000
0.00000000
0.00000000
0.00872500
0.00000000

assuming the non zero valu(0.008725) might fall in any row. how can i get
that value into cell B1?

sorry to bother you again.
what if there are chances that any 2 rows will be of equal values. but i
only one one of the row value to be in B1?