Thread: how to return random non zero value to a particular cell?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
  
Posts: 1,805
Default how to return random non zero value to a particular cell?
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?
Reply With QuoteReply With Quote