The REASON why you need the SUBTOTAL function instead of SUM

Опубликовано: 12 Ноябрь 2023
на канале: Open Training Camp

In this video, I show you how to use the AGGREGATE and the SUBTOTAL functions together in Excel to create robust calculations like Totals and Sub Totals. The aggregate function works with over 19 other functions like the AVERAGE function, COUNT function, COUNTA function, MAX function, MIN function, PRODUCT function, STDEV.S function, STDEV.P function, SUM function, VAR.S function, VAR.P function, MEDIAN function, MODE.SNGL function, LARGE function, SMALL function, PERCENTILE.INC function, QUARTILE.INC function, PERCENTILE.EXC function, QUARTILE.EXC function but in this video, we shall learn how to do a sum using the aggregate function.
The SUBTOTAL function also works with so many other functions with numerous other options and it's more dynamic and flexible than the simple SUM function.

If you would like to join our free weekly classes to learn about these functions in depth, kindly click this link below: https://chat.whatsapp.com/ImFuaZLuOZ8...

Смотрите видео The REASON why you need the SUBTOTAL function instead of SUM онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Open Training Camp 12 Ноябрь 2023, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 3 раз и оно понравилось людям.

9,58