| PureBytes Links Trading Reference Links | At 08:10 AM 6/4/01 -0400, you wrote:  >>>> I would like to set up a spreadsheet to track all of my trades after they are closed with a running summary. Is there a way with Excel to add all of the values in a column without specifying the end of the column? thanks, neo
 <<
 You can use the SumIf() statement to sum non-empty cells, like so:
 =SUMIF(A5:A14,"<>""")
 Best, Herman
 
 
 |