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