Home / Tech / Excel Basics / 14.6 Excel Function: SUBTOTAL()

14.6 Excel Function: SUBTOTAL()

What the subtotal function can do for you, this is excels subtotal function.

The subtotal function I’m going to F1, I started to type

Excel Function SUBTOTAL 1

There’s subtotal function, it’s asking me for two things. I’ll go hit the fx button, here’s argument window.

Excel Function SUBTOTAL 2

It’s got two arguments, It wants to know the function what type of subtotal do you want. Do you want a SUM, do you want a an Average, do you want to count what type of subtotal do you want Excel to perform on your data.

The next thing it wants to know is Ref1 or your reference your first reference. What’s the range of cells that you want to subtotal.

Function name is the number 1 to 11, It’s actually more than 11 that specifies the summary function for the subtotal. Essentially the Excel says you want a sum, then I need a specific number that represents that sum. If you want an average bill there’s a number that represents average. If you click the link help on this function mine just opened up over here this little help window will give you everything about the subtotal function by scroll down.

Excel Function SUBTOTAL 3

If I put a number 1 inside the function number one here it will function name. It will include hidden rows and it will do an average if I do a number. This one ignores hidden values so you hide rows may you go right click a row and you hide it one will ignore it and one will include it.

First example here I’m going to use a number 9 let me move that out of the way I’m going.

Excel Function SUBTOTAL 4

Excel Function SUBTOTAL 5

It just seems like more work than the SUM function right because he had to know the function of the function number. You know the associated function that goes along with that number is a bit more work but watch this. I’m going to look into my lists and what I’m going to do is filter the list by a division so quick and the list doesn’t matter where I’m good at data filter I get the little drop downs there I’m going to go to Division, I don’t want every division. Filter the list which changed my range here to just e records and my subtotal updated my SUM function.

Excel Function SUBTOTAL 6

This is your subtotal function, try this out.

About admin

Check Also

Excel Decimal Data Validation 1

15.2 Excel Decimal Data Validation

Create the little dropdown give the users the exact values for them to pick from. …

Leave a Reply

Your email address will not be published. Required fields are marked *