[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Excel Portfolio Tracker



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