0:00
hey everyone welcome back to Excel Wiz
0:04
In a previous video we covered how to
0:06
calculate the sum of filtered data in
0:08
Excel But what if you just want to count
0:11
how many you want to count how many
0:14
cells that are filtered in Excel For
0:17
example how many export transactions
0:19
were shipped to the USA So let's solve
0:22
this using this example
0:26
So to calculate this uh let's first
0:29
apply filters to our data
0:33
Highlight your your data and then let's
0:37
under data tab click on filter So
0:43
so we have filters on our data So let's
0:46
say we want to count how many shipments
0:50
Let's click um on the filter arrow and
0:53
country this filter arrow here and then
0:57
we'll have to uncheck all of them and
0:59
only click on the USA Click on okay Now
1:03
as you can see we only have data for for
1:06
the shipments that were sent to the USA
1:09
So we can we can try to use the normal
1:13
function that is the count to see if
1:16
this can calculate it Let's say count
1:28
as you can see that is it's it's not
1:31
working So that's not the formula that
1:33
we are supposed to use So to count the
1:36
filtered cells what we are going to use
1:39
we going to use the formula subtotal
1:49
but this time we are going to use count
1:54
Once you're done that you uh click comma
1:57
and then uh select your your cells
2:02
and click enter As you can see it only
2:04
calculated the first three the first
2:07
three cells that have the USA as a
2:14
So alternatively uh you can also use 103
2:19
So we can go sub total
2:25
and then use the 103 count a
2:30
comma and then select your cells This is
2:34
going to give you the same answer So you
2:38
for count function number three or
2:41
function number one or three Also for
2:44
they both ignore they manually ignore
2:47
the hidden rows That's why you can see
2:49
we only calculate the first three
2:53
But now what if we want to only count
2:56
ship exports to the USA We'll move on
3:03
We'll move to the status header Deselect
3:06
and just uh tick on shift When you click
3:10
okay as you can it it manually updates
3:12
it itself So that's how you can count
3:16
cells that are filtered in exam using
3:18
the subtotal formula with count number
3:22
three and 103 Uh thank you for watching
3:25
and if you have any questions please
3:27
feel free to send them on our comment
3:30
section and if you need a special video
3:32
for you please let us know in the
3:34
comment section as well And as always
3:36
thank you for watching and see you again
3:38
in the next video Bye
