x

Choose Country Code

x

Direction

x

Ask a Question

  • Ask a Question
  • Scan a Question
  • Post MCQ
  • Note: File extension must be of jpg, jpeg, png, bmp format and file size must not exceed 5 MB
x

Ask a Question

x

x
x
x
Hire a Tutor

Answers and Solutions

What's Your Question?
Answer

The SUBTOTAL is the OUTLINE option in DATA tab on the Ribbon. Also, there is a WORKSHEET FUNCTION in MS Excel.

Actually, the Subtotal is the total of records (rows) related to a particular data in columns sorted.

 

Answer

=subtotal(9, (sumrange)).

Answer

The SUBTOTAL function returns an aggregate result for supplied values. SUBTOTAL can return a SUM, AVERAGE, COUNT, MAX, and OTHERS,  and SUBTOTAL function can either include or exclude values in hidden rows. Get a subtotal in a list or database. A number representing a specific kind of subtotal.

Answer

it is totals at unique values in your excel workbook/worksheet.

you can calculate subtotal by using below formula

=subtotal(9,(sumrange)). 

When you type formula, you will see other functions also in subtotal like 1 is for avergae, 2 is for count..so on.

hope you got your answer...:)

Answer

Dear Rajarao,

There ar two things about subtotal, naming

1. SUBTOTAL ( Data Ribbon Menu Option): to group the data and make a quick summary out of a huge volume of data and it si mandatory to sort your data before application of the same.

2. Subtotal ( Worksheet FUnction): it contains a list of function basically in two categories. 

    1-11: which is applicable for teh data visible and Hidden as well

  101-111 : which is applicable for Visible data only.

Answer

Dear, it is totals at unique values in your excel workbook/worksheet.

you can calculate subtotal by using below formula

=subtotal(9,(sumrange)). 

When you type formula, you will see other functions also in subtotal like 1 is for avergae, 2 is for count..so on.

hope you got your answer...:)

Post Answer and Earn Credit Points

Get 5 credit points for each correct answer. The best one gets 25 in all.

Post Answer