Video yükleniyor...

Video Yüklenemedi

Ana Sayfaya Dön

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 görüntüleme • 3 yıl önce •via X (Twitter)

#Excel
LIVE

Anya Rossi• Live Now

Private livecam show

7 Yorum

Aham_Bramhasmi profil fotoğrafı
Aham_Bramhasmi3 yıl önce

Excel 2

Breadcrumb profil fotoğrafı
Breadcrumb1 yıl önce

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

Excellerate profil fotoğrafı
Excellerate3 yıl önce

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

Anil Agrawal, Chartered Accountant profil fotoğrafı
Anil Agrawal, Chartered Accountant3 yıl önce

Nice

Jaime Vargas J profil fotoğrafı
Jaime Vargas J3 yıl önce

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

hotdog profil fotoğrafı
hotdog3 yıl önce

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

kolluriK ॐ profil fotoğrafı
kolluriK ॐ3 yıl önce

What is the logic of these Numbers 9,7

Benzer Videolar

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 görüntüleme • 1 yıl önce

How to get day from data in excel
0:27

How to get day from data in excel

Today I Learned

51,869 görüntüleme • 2 yıl önce

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

How to get data from a database in Excel!

Storybridge

641,103 görüntüleme • 2 yıl önce

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 görüntüleme • 2 yıl önce

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 görüntüleme • 2 yıl önce

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 görüntüleme • 3 ay önce

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 görüntüleme • 1 ay önce

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 görüntüleme • 10 ay önce

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 görüntüleme • 1 yıl önce

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 görüntüleme • 7 ay önce

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 görüntüleme • 3 yıl önce

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 görüntüleme • 2 yıl önce

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 görüntüleme • 2 ay önce

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 görüntüleme • 1 yıl önce

🔜 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 görüntüleme • 1 yıl önce

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 görüntüleme • 3 yıl önce