How to not calculate hidden cells in excel

00:00I'm going to talk about doing calculations ignoring hidden rows so we

00:07have a table here of numbers and so let's scroll down to the bottom and so

00:12let's go in in this column which is calling code 2 and let's do an automatic

00:18sum and you reek you get the total of 4604.084 so that's that's

00:30perfect now let's go and select a bunch of : or a bunch of rows here and we're

00:37gonna hide these now the total doesn't change so sometimes you you would like

00:47to just total the numbers that are visible to you and you're not interested

00:51in totaling the numbers that you don't see so I'm gonna show you how to

00:56do this and with a function we're using is subtotal and so in the next the next

01:03cell below this I will go equals subtotal and what you do is you you

01:17select what you want to what type of calculation you'd like to do and it's

01:22you have average count and so I'd like to do some now some it's gonna give me

01:28the exactly the same thing it's gonna calculate all the numbers but if you add

01:32a hundred to this sum function you're going to get some without the totaling

01:39the numbers they can't see so let's go 109 and then we'll put a comma in there

01:46and then we will select the top of our range so we're gonna select from here

01:53until there and that's the range we wanted a subtotal and then we press put

02:01an ending bracket on here and there there we get the total of the values

02:05that you see as opposed to the total total of all the values include the

02:09first one is the one including the hidden values and this is just

02:13the values that you see so that's how you do functions using the subtotal so