The writers of the Billy Goat Gruff story had really observed what goats ate. Is green grass good for goats? Yes, green grass is the generally the most nutritive food available for goats and it is the cheapest food. During spring the green pasture is usually about 80% digestible and has a crude protein content of 20%. Most of the fibrous parts of the pasture are still quite digestible by the goat.
If you want to sum up a column in Excel and keep the result in your table, you can employ the AutoSum function. It will automatically add up the numbers and will show the total in the cell you select. To avoid any additional actions like range selection, click on the first empty cell below the column you need to sum.
If you then insert a cell over cell A1 so that the value 10 is moved to cell A2, the formula in cell B1 is =$A$2.. To anchor the same reference while you insert or delete rows, columns, or cells, use the INDIRECT worksheet function.For example, if you want Excel to always reference cell A1, use the following formula:Below is an example of a formula that would use the INDIRECT function to always sum the first 10 rows of column A: Back to the top | Give Feedback.or example, if you type the value 10 in cell A1 and refer to it in cell B1 with the formula =$A$1 (without the quotation marks), the value 10 appears in cell B1.