Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

Can anyone explain Subtotal function in Excel?

user-image
Question added by Deleted user
Date Posted: 2014/06/02
Deleted user
by Deleted user

and What's the syntax?

Deleted user
by Deleted user

SUBTOTAL formula is used to find out subtotal of a given range of cells

FITAH MOHAMED
by FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials

simply 

subtotal used to get  result of one  function in  range been   filtered

subtotal = ( function num ; ref1:...............)

function num  that used in subtotal are

1= average

2= count 

3 = counta

4 = max

5 = min

6 = product

7 = stdv . s

8 = stdv.p

9 = sum

10 = var.s

11 = var.p

tanks 

 

Paul Ricmond Fernandez
by Paul Ricmond Fernandez , Warehouse Controller , Daiho Phil. Inc

subtotal of excel is used to determine the output of every number that you are input. for example you are using the arithmetic1+1=2 the subtotal is2 because it is the output of the number that you are input. the subtotal function is used by the numbers, signs and colors.

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.