Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.
Suppose you have listed Le Napoleon's monthly sales of pear tortes in a twelve-sheet workbook. The first worksheet contains January sales, the second...
Suppose you have listed Le Napoleon's monthly sales of pear tortes in a twelve-sheet workbook. The first worksheet contains January sales, the second worksheet February sales, etc. The pear torte sales are always listed in cell F7.What multi-sheet (three-dimensional) formula would give the total pear torte sales for the months March-July, inclusive? Assume that each worksheet is named with the month name only, spelled out in full.Include the equal sign at the beginning—for example, =SUM(A1:A24)—but do not include any unnecessary spaces or parentheses in your response. Also do not anchor any cells—i.e., do not use any $ characters