How to use COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS formula in MS Excel | Attendance Sheet

  Рет қаралды 153

Computer Skill

Computer Skill

11 ай бұрын

This easy Hindi tutorial of Microsoft Excel 2016/2013/2010/2007 is about COUNT Formulas.
In this basic tutorial for beginners, you will learn how to use COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS formula.
You can calculate numeric values in selected rows or columns with the help of COUNT formula. You can use COUNTA formula, if you want to check that how many alphabets or numbers are there in selected rows or columns. With the help of COUNTBLANK formula, you can check that how many blank cells are there in your data. COUNTIF formula is used to count cells in a range, that meets a particular criterian. COUNTIFS formula counts the number of cells in a range, that meets single or multiple criteria.
Microsoft Excel 2021/2016/2013/2010/2007 ka yah aasan tutorial COUNT formulas ke bare me hai.
Is basic tutorial me aap COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS formulon ka upyog karna sikhenge.
Count formula kisi column ya row me kitni cells hain, yeh count karne ke liye upyog kiya jata hai. Dhyan me rakhe yeh sirf unhi cells ko count karega jinme numeric values ho.
Counta formule ki sahayata se aap selected range me kitne alphabets ya numbers hain, yah count kar sakte hain.
Countblank formule se aap yeh count kar sakte hain, ki apke data me kitne blank cells hain.
Countif formula kisi column ya row me condition ke according values ko count karta hai.
countifs formula, do ya do se adhik conditions me values ko count karne ke liye use kiya jata hai.
#excel
#computer
#basic #autocad
#microsoftoffice
#microsoftexcel
#microsoft_excel_tutorial
#microsoft
#ms Ms Excel tips and tricks
#shortvideo
#spreadsheetsoftware
Your Query
Excel in hindi,excel tutorial in hindi,ms excel in hindi,ms excel tutorial in hindi,learn excel in hindi,vlookup in excel in hindi,learn ms excel in hindi,excel training,excel tutorial,microsoft excel 2007,learn excel,tutorial excel,ms excel tutorial,excel tutorials,ms excel 2007,microsoft excel training,learn excel online,learning excel,free excel training,online excel training,advanced
#sumif
#vlookup
#countif
#counting
#countifs
#ms Excel formula
#formula
Thank for watching friends
and
welcome my channel ‎@Computer_Gyan_1
like share & Subscribe my channel
माइक्रोसॉफ्ट एक्सेल 2016/2013/2010/2007 का यह आसान ट्यूटोरियल COUNT formulas के बारे में है |
इस बेसिक हिंदी ट्यूटोरियल में आप COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS फोर्मुलों का उपयोग करना सीखेंगे |
Count formula किसी column या row में कितनी cells है, यह काउंट करने के लिए उपयोग किया जाता है। ध्यान रखें यह सिर्फ उन्ही cells को काउंट करेगा जिनमे numerical values हो |
Counta formule की सहायता से आप सिलेक्टेड रेंज में कितने अल्फाबेट्स या नंबर्स हैं, यह काउंट कर सकते हैं |
Countblank formule से आप यह काउंट कर सकते हैं, की आपके डाटा में कितने blank सेल्स हैं |
Countif formula किसी column या row में condition के according values को काउंट करता है |
Countifs formula, दो या दो से अधिक conditions में values को काउंट करने के लिए use किया जाता है |

Пікірлер: 3
@rajendragurjar1444
@rajendragurjar1444 11 ай бұрын
Very good
@ComputerSkill.
@ComputerSkill. 10 ай бұрын
Thanks
@VinodRawat-ff3ti
@VinodRawat-ff3ti 10 ай бұрын
👍
КАК ДУМАЕТЕ КТО ВЫЙГРАЕТ😂
00:29
МЯТНАЯ ФАНТА
Рет қаралды 3,8 МЛН
One moment can change your life ✨🔄
00:32
A4
Рет қаралды 15 МЛН
THEY WANTED TO TAKE ALL HIS GOODIES 🍫🥤🍟😂
00:17
OKUNJATA
Рет қаралды 23 МЛН
50 things you didn't know Excel can DO 💡
30:03
Chandoo
Рет қаралды 267 М.
Level grid sheet in highway and calculate in Ms Excel | Surveyor
10:32
Earthwork Sheet for Calculate the Cutting & Filling of the road
4:54
Musharaf Ahmed
Рет қаралды 4,6 М.
Earthwork Calculation 2
6:20
Atme Civil Mysore
Рет қаралды 18 М.
КАК ДУМАЕТЕ КТО ВЫЙГРАЕТ😂
00:29
МЯТНАЯ ФАНТА
Рет қаралды 3,8 МЛН