Загрузка видео...

Не удалось загрузить видео

На главную

How to Exclude the Hidden Rows Data & Errors to Get the Total? in Microsoft #Excel | SUM vs. SUBTOTAL vs. AGGREGATE =AGGREGATE(9,7,C6:C14)

ExcelBasement's profile picture

Excel Basement

33,599 subscribers

151,345 просмотров • 3 лет назад •via X (Twitter)

#Excel
LIVE

Anya Rossi• Live Now

Private livecam show

Комментарии: 7

Фото профиля Aham_Bramhasmi
Aham_Bramhasmi3 лет назад

Excel 2

Фото профиля Breadcrumb
Breadcrumb1 год назад

Looking to automate reporting? Use AI agents to turn spreadsheets to reports in minutes without any coding.

Фото профиля Excellerate
Excellerate3 лет назад

You could also create a table and filter out the hidden rows data & errors.

Фото профиля Anil Agrawal, Chartered Accountant
Anil Agrawal, Chartered Accountant3 лет назад

Nice

Фото профиля Jaime Vargas J
Jaime Vargas J3 лет назад

Cuál sería el comando en su versión en español?

Фото профиля hotdog
hotdog3 лет назад

Que es el 109 en el subtotal 109? También que es el 9 y el7 de Agregate{9.7?

Фото профиля kolluriK ॐ
kolluriK ॐ3 лет назад

What is the logic of these Numbers 9,7

Похожие видео

Dear Data Analyst, learn how to use List with VLOOKUP in Microsoft Excel Watch this video 😍 Microsoft Excel Jessica Ayodele Ezekiel
0:35

Dear Data Analyst, learn how to use List with VLOOKUP in Microsoft Excel Watch this video 😍 Microsoft Excel Jessica Ayodele Ezekiel

Zehida

31,364 просмотров • 1 год назад

How to get day from data in excel
0:27

How to get day from data in excel

Today I Learned

51,869 просмотров • 2 лет назад

How to get data from a database in Excel!
0:44

How to get data from a database in Excel!

Storybridge

641,103 просмотров • 2 лет назад

A rifle by India's largest PSU in defence with the aggregate funding of Rs 23,264 crore. Vs A rifle made by some tribals in Pakistan.
0:26

A rifle by India's largest PSU in defence with the aggregate funding of Rs 23,264 crore. Vs A rifle made by some tribals in Pakistan.

Elite Predators

455,435 просмотров • 2 лет назад

Python in Excel! Microsoft has announced Python and Excel integration today. Python in Excel brings the power of Python analytics into Excel. Use it to process data in Excel with Python code. More details 🧵👇
1:30

Python in Excel! Microsoft has announced Python and Excel integration today. Python in Excel brings the power of Python analytics into Excel. Use it to process data in Excel with Python code. More details 🧵👇

Afiz ⚡️

1,671,189 просмотров • 2 лет назад

INCREDIBLE SCENES IN LISBON 🟢 Sporting get their fourth on the night to TAKE THE LEAD over Bodø/Glimt, 4-3 on aggregate 🤯
1:40

INCREDIBLE SCENES IN LISBON 🟢 Sporting get their fourth on the night to TAKE THE LEAD over Bodø/Glimt, 4-3 on aggregate 🤯

CBS Sports Golazo ⚽️

37,791 просмотров • 3 месяцев назад

Stamford Bridge under the lights. Mourinho vs Rodgers. After the 1-1 draw at Anfield, the second leg ended 1-0 to Chelsea thanks to Ivanović’s header in the 94th minute from a Willian free-kick. Chelsea won 2-1 on aggregate. #CFC
3:35

Stamford Bridge under the lights. Mourinho vs Rodgers. After the 1-1 draw at Anfield, the second leg ended 1-0 to Chelsea thanks to Ivanović’s header in the 94th minute from a Willian free-kick. Chelsea won 2-1 on aggregate. #CFC

JOSHUA RHODES | CFC 🦁

148,739 просмотров • 1 месяц назад

Club Brugge score TWICE in three minutes to close the half 8–1 ahead on aggregate 😮
0:30

Club Brugge score TWICE in three minutes to close the half 8–1 ahead on aggregate 😮

Sky Sports Scotland

219,188 просмотров • 10 месяцев назад

Microsoft 365 Copilot in Excel with Python, now in preview, allows you to: ➡️ Perform advanced data analysis ➡️ Create sophisticated visualizations Unlock the power of Python with Copilot. #AI #Excel
0:33

Microsoft 365 Copilot in Excel with Python, now in preview, allows you to: ➡️ Perform advanced data analysis ➡️ Create sophisticated visualizations Unlock the power of Python with Copilot. #AI #Excel

Microsoft 365

100,591 просмотров • 1 год назад

We charge by the truck, not by the hour. When you pay $10,000 for a truck load of aggregate we try to get in and out in 90 seconds flat. We deliver 100 truck loads a day with our Aggregate Cannon. Unrelated, I’m shopping for a new Denali this weekend.
0:45

We charge by the truck, not by the hour. When you pay $10,000 for a truck load of aggregate we try to get in and out in 90 seconds flat. We deliver 100 truck loads a day with our Aggregate Cannon. Unrelated, I’m shopping for a new Denali this weekend.

Mason Home Builder

3,358,137 просмотров • 7 месяцев назад

How to get data from database in Excel! 🗂️ Don’t forget to save this post! #excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials
0:52

How to get data from database in Excel! 🗂️ Don’t forget to save this post! #excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials

CheatSheets

565,099 просмотров • 3 лет назад

How to use the INDEX + MATCH functions to search for data in Excel‼️ ❤️ and follow CheatSheets for daily tips‼️ #excel
0:53

How to use the INDEX + MATCH functions to search for data in Excel‼️ ❤️ and follow CheatSheets for daily tips‼️ #excel

CheatSheets

27,822 просмотров • 2 лет назад

Never-before-seen footage of how Palantir’s Maven Smart System actually works: “It gives us the ability to take classified, unclassified, and commercial data—and you can aggregate it all together to help you make all the decisions that you have to in warfare.” Via Channel 4
2:08

Never-before-seen footage of how Palantir’s Maven Smart System actually works: “It gives us the ability to take classified, unclassified, and commercial data—and you can aggregate it all together to help you make all the decisions that you have to in warfare.” Via Channel 4

Jawwwn

478,813 просмотров • 2 месяцев назад

Microsoft has just announced Copilot's ability to process data in Excel by generating Python code. - Request a detailed analysis - Copilot generates Python - Excel executes the code to show the result All without having to write a single formula. Just natural language. Huge deal for data analysis and visualization.
1:09

Microsoft has just announced Copilot's ability to process data in Excel by generating Python code. - Request a detailed analysis - Copilot generates Python - Excel executes the code to show the result All without having to write a single formula. Just natural language. Huge deal for data analysis and visualization.

Paul Couvert

373,713 просмотров • 1 год назад

🔜 Spain (2) vs (2) Netherlands It’s all square on aggregate as the sides battle it out in the second leg at the Mestalla! Join Aarran Summers, Adlene GUEDIOURA & Didier Domi on beIN SPORTS 1 EN for tonight’s #NationsLeague coverage! #ESPNED 🇪🇸🇳🇱
1:26

🔜 Spain (2) vs (2) Netherlands It’s all square on aggregate as the sides battle it out in the second leg at the Mestalla! Join Aarran Summers, Adlene GUEDIOURA & Didier Domi on beIN SPORTS 1 EN for tonight’s #NationsLeague coverage! #ESPNED 🇪🇸🇳🇱

beIN SPORTS

10,561 просмотров • 1 год назад

How to get data from a screenshot in Excel! 🗂️ Don’t forget to save this post! #excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials
0:34

How to get data from a screenshot in Excel! 🗂️ Don’t forget to save this post! #excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials

CheatSheets

215,773 просмотров • 3 лет назад