Video wird geladen...

Video konnte nicht geladen werden

Zur Startseite

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 Aufrufe • vor 3 Jahren •via X (Twitter)

#Excel
LIVE

Anya Rossi• Live Now

Private livecam show

7 Kommentare

Profilbild von Aham_Bramhasmi
Aham_Bramhasmivor 3 Jahren

Excel 2

Profilbild von Breadcrumb
Breadcrumbvor 1 Jahr

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

Profilbild von Excellerate
Excelleratevor 3 Jahren

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

Profilbild von Anil Agrawal, Chartered Accountant
Anil Agrawal, Chartered Accountantvor 3 Jahren

Nice

Profilbild von Jaime Vargas J
Jaime Vargas Jvor 3 Jahren

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

Profilbild von hotdog
hotdogvor 3 Jahren

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

Profilbild von kolluriK ॐ
kolluriK ॐvor 3 Jahren

What is the logic of these Numbers 9,7

Ähnliche Videos

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 Aufrufe • vor 1 Jahr

How to get day from data in excel
0:27

How to get day from data in excel

Today I Learned

51,869 Aufrufe • vor 2 Jahren

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

How to get data from a database in Excel!

Storybridge

641,103 Aufrufe • vor 2 Jahren

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 Aufrufe • vor 2 Jahren

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 Aufrufe • vor 2 Jahren

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 Aufrufe • vor 3 Monaten

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 Aufrufe • vor 1 Monat

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 Aufrufe • vor 10 Monaten

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 Aufrufe • vor 1 Jahr

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 Aufrufe • vor 7 Monaten

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 Aufrufe • vor 3 Jahren

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 Aufrufe • vor 2 Jahren

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 Aufrufe • vor 2 Monaten

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 Aufrufe • vor 1 Jahr

🔜 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 Aufrufe • vor 1 Jahr

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 Aufrufe • vor 3 Jahren