filmov
tv
Excel - How to SUM visible cells only
Показать описание
In this short video I show simple way how to Sum visible cells only.
I create filter for table and using Subtotal() function I calculate Sum, Count and Average from visible table data.
I create filter for table and using Subtotal() function I calculate Sum, Count and Average from visible table data.
0:00:38
0:02:10
0:01:02
0:00:06
0:00:56
0:01:50
0:00:19
0:07:53
0:01:26
0:00:10
0:00:08
0:00:25
0:03:57
0:00:59
0:00:51
0:02:34
0:00:07
0:04:10
0:03:07
0:00:21
0:01:16
0:02:24
0:00:30
0:00:18