Excel 2011 for MAC. I want to insert some subtotals which is easy enough but I cant find the command on the MAC 2011 version. Where is this hidden? I have looked on every tab in the ribbon but I sure dont see it anywhere. Missing SUBTOTAL Command.
![]()
To use this feature, your list must be sorted, because the subtotals are inserted whenever the value in a specified field changes.
To insert subtotal formulas into a list automatically, move the cell pointer anywhere in the list and on the Data tab, in the Outline group, choose Subtotal:
This dialog box offers the following choices:
When you click OK, Excel analyzes the list and inserts formulas as specified - and creates an outline for you. The formulas all use the SUBTOTAL worksheet function.
This Excel tutorial explains how to use the Excel SUBTOTAL function with syntax and examples.
Description
The Microsoft Excel SUBTOTAL function returns the subtotal of the numbers in a column in a list or database.
The SUBTOTAL function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the SUBTOTAL function can be entered as part of a formula in a cell of a worksheet.
Syntax
The syntax for the SUBTOTAL function in Microsoft Excel is:
Parameters or Arguments
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |