I'm having trouble setting up a formula in one sheet to get totals from
another sheet in the same workbook. When I set the formula, the formula
itself is displayed and not the value I need from the cell(s) in the other
sheet. I also get a formula error arrow in the cell. Any ideas?