Subtotal in excel 365

Excel 365 on a Chromebook may have some limitations compared to the full desktop version of Excel. The Subtotal feature, which is found in the Data tab on Windows versions of Excel, is currently not available in the web-based version of Excel (which is what you are using on your Chromebook).

Workarounds:

Since you are an experienced Excel user, here are a few ways you can still achieve subtotals:

 1. Use SUMIFS or AGGREGATE Instead

• If you were using the Subtotal feature to group and sum data, you can use SUMIFS, AGGREGATE, or FILTER functions.
• Example: SUMIFS(B:B, A:A, "Category1") would sum values in column B where column A equals "Category1".

2. Use Pivot Tables

• Even though the Subtotal function isn't available, you can use PivotTables in Excel Online.
• Select your data → Click Insert → PivotTable → Choose your settings.
• This is a powerful alternative to subtotals.

3. Use Excel Desktop (if possible)

• If you have access to a Windows or Mac computer, you can open your Excel file in the full version of Excel and use the Subtotal function there.
• Alternatively, if you have Excel for Android, you might check if it has the Subtotal function available.

You’re not necessarily "downgraded," but Excel for the Web lacks some advanced features found in the full desktop version. The best workaround is to use PivotTables or formulas like SUMIFS. If you absolutely need Subtotal, you’ll need to use Excel on a Windows/Mac device.

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark as best response and like it!

This will help all forum participants.