I want to pre-load all my formulas across and down the spreadsheet as I start to note and line-chart 5 months of data on a daily basis.
One of my formulas across the columns is:
IF(E2="","",SUM(B2:D2))
What I am trying to do by this is say, "if there is nothing in cell E2, don't compute and don't show anything on that "tick" of the chart (and also, don't show anything in the E2 cell on the spreadsheet), but if there is something in Cell E2 on the spreadsheet, then compute the SUM(B2:D2) formula, and then show the results of that computation on the appropriate "tick" of the line chart.
One attempted solve is:
IF(E2="",NA(),SUM(A2:D2)) - however, this puts a #N/A or somesuch in the empty cell (E2) on the spreadsheet (remember, the formulas are all pre-loaded) - I want the spreadsheet "clean" until the pre-loaded formula must compute some data that is placed on that row (my input data goes from columns A through D, my formulas go across the spreadsheet from E to AM and down to row 110, so my spreadsheet and charts can get quite confusing with too much clutter.
Can anyone help???????
One of my formulas across the columns is:
IF(E2="","",SUM(B2:D2))
What I am trying to do by this is say, "if there is nothing in cell E2, don't compute and don't show anything on that "tick" of the chart (and also, don't show anything in the E2 cell on the spreadsheet), but if there is something in Cell E2 on the spreadsheet, then compute the SUM(B2:D2) formula, and then show the results of that computation on the appropriate "tick" of the line chart.
One attempted solve is:
IF(E2="",NA(),SUM(A2:D2)) - however, this puts a #N/A or somesuch in the empty cell (E2) on the spreadsheet (remember, the formulas are all pre-loaded) - I want the spreadsheet "clean" until the pre-loaded formula must compute some data that is placed on that row (my input data goes from columns A through D, my formulas go across the spreadsheet from E to AM and down to row 110, so my spreadsheet and charts can get quite confusing with too much clutter.
Can anyone help???????