Subtotal Function Archives - Page 7 of 7

Subtotal Function

How to AutoFill Numbers in Excel (12 Ways)

May 12, 2022 Excel Basics

There are several short and quick methods to autofill numbers in Microsoft Excel. In this article, you’ll learn how you can easily apply those useful ...

12 Automatic Ways of Numbering in Excel

Jan 26, 2023 Excel Basics

While dealing with a large dataset, you may need to assign automatic numbers to your cells. However, manually applying the number is a tedious task. ...

How to Copy a Formula in Excel with Changing Cell References

Feb 9, 2023 Excel Basics

Do you need to copy a formula or function in Excel with or without changing cell references? There are lots of ideas and techniques to do it without ...

How to Sum Last 5 Values in a Row in Excel (5 Handy Approaches)

Feb 16, 2023 Excel Formulas

We frequently add up a series of numbers, but in certain cases, we may need to sum the last 5 values in a row in Excel. In this article, I’ll discuss ...

How to Sum Multiple Rows Using INDEX MATCH Formula

Feb 7, 2023 Excel Formulas

Microsoft Excel is a powerful program where we can perform numerous operations on our datasets using its tools and features. In many instances, you ...

How to Count Visible Rows in Excel (3 Suitable Methods)

Feb 7, 2023 Excel Formulas

While dealing with a large dataset, adding many rows to your worksheet is necessary. But at the same time, you may need to hide some rows to give the ...

How Do I Count Cells with Text In Excel (8 Quick Tricks)

Feb 27, 2023 Excel Formulas

In this tutorial, I am going to show you 8 quick tricks to count cells with text in excel. You can use these methods even in large datasets to find ...

Top Excel Functions and Features for Management Consultants

Dec 14, 2022 Advanced Excel 1

For management consultants who must conduct data analysis and give presentations to clients, Microsoft products are truly incredible resources. And ...