Loading video...

Video Failed to Load

There was a problem loading this video. This could be due to a temporary network issue or the video might be unavailable.

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)

Excel Basement

33,599 subscribers

151,345 views • 3 years ago •via X (Twitter)

Anya Rossi• Live Now

Private livecam show

7 Comments

Aham_Bramhasmi3 years ago

Excel 2

Breadcrumb1 year ago

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

Excellerate3 years ago

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

Anil Agrawal, Chartered Accountant3 years ago

Nice

Jaime Vargas J3 years ago

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

hotdog3 years ago

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

kolluriK ॐ3 years ago

What is the logic of these Numbers 9,7

Related Videos

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

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

Zehida

31,364 views • 1 year ago

How to get day from data in excel

How to get day from data in excel

Today I Learned

51,869 views • 2 years ago

How to get data from a database in Excel!

How to get data from a database in Excel!

Storybridge

641,103 views • 2 years ago

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.

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 views • 2 years ago

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 🧵👇

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 views • 2 years ago

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

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 views • 3 months ago

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

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 views • 1 month ago

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

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

Sky Sports Scotland

219,188 views • 10 months ago

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 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 views • 1 year ago

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.

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 views • 7 months ago

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

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 views • 3 years ago

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

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

CheatSheets

27,822 views • 2 years ago

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

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 views • 2 months ago

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.

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 views • 1 year ago

🔜 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 🇪🇸🇳🇱

🔜 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 views • 1 year ago

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

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 views • 3 years ago