I already have a straight line showing the target achievement and I want to be able to project how close to target achievement is looking as time passes. But if my sales start running at $150/day (the last figure in the row), I now want to show a cumulative total that will give a more sharply inclined line on the graph. This scenario allows you to return values based on whether or not a cell contains any value at all. If cell contains any value, then return a value. Contact our experts if you need any further assistance. If you’re using a different version or platform, some steps may vary. The guides below were written using the latest Microsoft Excel 2019 for Windows 10. For example, if the figures suggest that I am achieving sales of $100/day today, a cumulative total would show a straight rising line on a graph. Using if cell contains formulas in Excel. I want to create a line in a chart that represents the average achievement at any given moment and extrapolates it over the remainder of the period. The Google one makes use of the INDEX and COUNTA formulae but I just get an exclamation mark in a red triangle. The Excel formula includes a FILTER function that doesn’t exist in Numbers. I have found ways to do that in both Excel and GoogleDocs but the formulae don’t work in Numbers. I want to be able to retrieve to the contents of the last cell in a row for a formula (which updates as cells become populated). I have a spreadsheet that I regularly update, which populates blank cells in columns. How Do I Return the Contents Of the Last Non-Empty Cell In a Row or Column?
