正在加载视频...

视频加载失败

返回首页

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 次观看 • 4 个月前

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 年前

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 年前

🔜 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 年前