What is the Subtotal feature in Excel?

Asked by Last Modified  

Follow 1
Answer

Please enter your answer

IT professional with 3 Years of Experience

a formula that calculates a range of values based on a specific function. This appears as =SUBTOTAL(function_number, ref1, ,...) where function_number refers to the function you want the formula to fill.
Comments

Related Questions

How many columns can be created in MS Excel?
Hi Manisha, Default Columns in Excel updated versions like 200, 2010, 2013,....... are 16384 Columns , Starts from A-XFD
Manisha
0 0
5
What are the 5 most essential excel tools to master?
tools? Is that right, is that what you wanna know? there is no such thing as tools inbuilt in excel. Tools are specifically designed for a set of people or a company for a specific purpose to be added...
Yashraj
0 0
6
Is MS Excel very easy to learn?
Yes it is easy application to learn
Kamal
0 0
6
Are there any VBA tutors around Secunderabad?
Tell me your requirement. I shall guide u online.
V

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

Microsoft Excel
For the following data, determine the discount rate for which the total payable amount will be Rs. 45000 Particulars Qty Rate Amount LG Washing machine 2 23800 47600 Discount (%) ...

VBA Function - INSTR
INSTR works similar to FIND function in Excel. INSTR search for specific text in a given text and returns the position number of what you are searching for. Syntax: InStr( , string, searchingfor, ) Sub...

VBA Function -
Using FORMAT Function in VBA we can modify the format of Numbers, Dates, Times & String. Syntax: FORMAT(expression, format, , ) 1. Formatting "Numbers" using FORMAT function in VBA SUB Format_Numbers() MsgBox...

What are the function categories on Excel?
Function Categories There are many categories of functions in Excel. Each category has specific functions that pertain to that category. Financial: Performs common business calculations including accounting...

Hidden Gems of MS Excel - New Window
You are working on 2 Worksheets in Same Workbook. To complete Your task, You have to frequently navigate between the Worksheets.Understandably, to frequently navigate between the Worksheets is inconvenient,...

Recommended Articles

Microsoft Office is a very popular tool amongst students and C-Suite. Today, approximately 1.2 billion people across 140 countries use the office programme. It is used at home, schools and offices on a daily basis for organizing, handling and presenting data and information. Microsoft Office Suite offers programs that can...

Read full article >

Hadoop is a framework which has been developed for organizing and analysing big chunks of data for a business. Suppose you have a file larger than your system’s storage capacity and you can’t store it. Hadoop helps in storing bigger files than what could be stored on one particular server. You can therefore store very,...

Read full article >

Whether it was the Internet Era of 90s or the Big Data Era of today, Information Technology (IT) has given birth to several lucrative career options for many. Though there will not be a “significant" increase in demand for IT professionals in 2014 as compared to 2013, a “steady” demand for IT professionals is rest assured...

Read full article >

Software Development has been one of the most popular career trends since years. The reason behind this is the fact that software are being used almost everywhere today.  In all of our lives, from the morning’s alarm clock to the coffee maker, car, mobile phone, computer, ATM and in almost everything we use in our daily...

Read full article >

Looking for Microsoft Excel Training classes?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you