Loading...
「ツール」は右上に移動しました。
利用したサーバー: wtserver3
17いいね 272回再生

How to Correct the Serial Number of Filtered Data - Get the Sum of Filtered Data in Excel

How to Correct the Serial Number of Filtered Data - Get the Sum of Filtered Data in Excel (Using SUBTOTAL Formula)

Hello friends, in this video you will learn how you can total the filtered data. Apart from this, how can we correct the serial number of the filtered data. Whenever we filter the data, the serial number often gets corrupted. So how to correct it, you will learn in today's video.

नमस्कार दोस्तों इस वीडियो में आप जानेंगे की आप किस तरह से फ़िल्टर डाटा का टोटल कर सकते है। इसके अलावा फ़िल्टर डाटा का सीरियल नंबर कैसे कररेक्ट कर सकते है। जब भी हम डाटा का फ़िल्टर करते है तो अक्सर सीरियल नंबर बिगड़ जाता है। तो उसे कैसे सही किआ जाता है आज की इस वीडियो में आप जानेंगे।


Namaskaar doston is veediyo mein aap jaanenge kee aap kis tarah se filtar daata ka total kar sakate hai. isake alaava filtar daata ka seeriyal nambar kaise kararekt kar sakate hai. jab bhee ham daata ka filtar karate hai to aksar seeriyal nambar bigad jaata hai. to use kaise sahee kia jaata hai aaj kee is veediyo mein aap jaanenge.

Time Stamp:
00:00 Introduction
02:57 How to the Sum of Filtered Data in Excel (Using SUBTOTAL Formula)
04:17 How to correct the serial number of filtered data



In such cases, when you want to get the sum of filtered data only (i.e., the cells that are visible), you can use the SUBTOTAL function. SUBTOTAL function can ignore hidden rows (either through filters or done manually) and can give you the following values:
-- SUM
-- AVERAGE
-- COUNT
-- COUNTA
-- MAX
-- MIN
-- PRODUCT
-- STDEV.P
-- STDEV.S
-- VAR.S
-- VAR.P
#excelinfotech #excel #subtotal #filter #msoffice #advanceexcel
tags:
get sum of filtered cells excel, how to get sum of filtered data in excel, how to get sum of filtered column in excel, subtotal in excel, subtotal sum function in excel, subtotal sum in excel, subtotal filtered data in excel, sum filtered data in excel, excel sum filtered rows only, advanced excel, excel, excel basics, excel in 2 minutes, excel in two minutes, excel tips, excel tutorials, learn excel, sumit bansal, trump excel, microsoft excel,excel infotech,auto generate serial number in excel, auto serial number in excel in hindi, auto-numbering in excel after row insert, automatic serial number in excel formula, automatically insert serial number after filter in excel, automatically number columns in excel, excel, excel formula to generate unique sequential numbers, filling a certain number of rows in excel automatically, how do i turn on automatic numbering in excel? auto serial number in excel formula


हर रोज नया वीडियो ट्यूटोरियल हिन्‍दी में पाने के लिये हमारा यूट्यूब चैनल सबस्‍क्राइब करें और घर बैठे ही जॉइन करें Excel Infotech स्‍मार्ट क्‍लास 👈

My Playlist:-
AI Web Tools
   • AI Web Tools  
New Tally Prime 4.1
   • Tally Prime New  
Tally Prime
   • Tally Prime  
Busy21
   • Busy 21  
Ms Word 2019
   • Ms Word  
Ms Excel 2019
   • Ms Excel 2019  
Excel Sheets
   • Excel Sheets  
Corel Draw 2021
   • CorelDraw2024  
Photoshop Cs6
   • Photoshop  
Income Tax Department
   • Income Tax Department  
Computer Hardware Solution
   • Computer Solution  
CSC Vles
   • CSC VLEs  
Shorts
   • Shorts  

Disclaimer- Some contents are used for educational purpose under fair use. Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use. All credit for copyright materiel used in video goes to respected owner.

Don't forget to - LIKE 👍 | SHARE 🤗 | COMMENT 💁 | SUBSCRI

コメント