Suppose you have listed Le Napoleon\'s monthly sales of pear tortes in a twelve-

Question

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.

Explanation / Answer

=SUM(March:July!F7)

Since the total sales are always listed on cell F7 in each of the sheet from Janauary to December. And if we want to consolidate the total sales from month of March till July we can use the above formual we will get the sales for these months.

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.