I place "Open, High, Low, Close" data on a daily basis (110 rows in all) and use formulas going from column F to AM.
A sample formula would be:
IF(E13="","",SUM(N7:N13)). Column E is where I place the closing price.
What I want - If there is nothing in cell E13 of the spreadsheet, don't compute and don't show anything on the row 13 "tick" of the line chart (nor show anything in cell N13 of the spreadsheet - where the formula is pre-loaded), but if there is something in cell E13, then compute the SUM(N7:N13) pre-loaded formula, and then show the results of that computation in cell N13 of the spreadsheet, as well as the results of that computation on the applicable row 13 "tick" of the line chart.
I want to keep the spreadsheet "clean" until I have placed "Open, High, Low, Close" data on each row and then have the formulas along each specific row "automatically" do all their calculations and fill in the answers, both on the spreadsheet and on the various charts linked to that spreadsheet.
tlotzer@harmoninc.com
A sample formula would be:
IF(E13="","",SUM(N7:N13)). Column E is where I place the closing price.
What I want - If there is nothing in cell E13 of the spreadsheet, don't compute and don't show anything on the row 13 "tick" of the line chart (nor show anything in cell N13 of the spreadsheet - where the formula is pre-loaded), but if there is something in cell E13, then compute the SUM(N7:N13) pre-loaded formula, and then show the results of that computation in cell N13 of the spreadsheet, as well as the results of that computation on the applicable row 13 "tick" of the line chart.
I want to keep the spreadsheet "clean" until I have placed "Open, High, Low, Close" data on each row and then have the formulas along each specific row "automatically" do all their calculations and fill in the answers, both on the spreadsheet and on the various charts linked to that spreadsheet.
tlotzer@harmoninc.com