Top 10 COUNTIF Excel Maharaj Questions and Answers

[@saddammalik5566]

I have no idea these questions how to solve...but now learned by you and extremely thankful।।।।।

[@dipak5651]

Awesome video. Amazing explanation

[@aqeelahmadengr3]

Sir, you are very good teacher. I learn many things from you.

[@samsuddinansari1739]

Sir your video is so excellenc Thanks for interview base questions

[@aruncheeli1]

Ek b nahe pata tha. Learning lot now.

[@Learn_withkd]

Very informative Sir 👍👍👍

[@aqeelahmadengr3]

Thank you

[@sandeepaswal8944]

Sir I have come to know so much about Excel, the credit goes to you only. Because I have read each of your videos thoroughly and will continue to take knowledge from you in future also. I know 10 of 10 .They are really very helpful for interview.

[@Innozant]

Thanks Aswal Sahab.Happy learning dear.God bless you❤️

[@niteshmandal5816]

Thanku sir g ❤❤

[@vikasgawaria5330]

Nice video sir thank you so much

[@Narendar.pathak]

Thanks sir kuch countif ke formula mujhe nahi maloom the aur kabhi try bhi nahi kiya tha aaj ki video se sikhne ko mila

[@Innozant]

Thanks Narender ji.Happy Learning

[@ganeshshelar3597]

Very good teaching....

[@Innozant]

Thanks dear❤️

[@createyour6681]

Very great sir

[@Innozant]

Thanks dear

[@satishojha6240]

Thanku for the video sir 🙏🙏🙏🙏. Good night

[@Innozant]

Thanks Satish ji .Good Night❤️❤️

[@sathyanarayana4914]

Very beautiful question

[@Innozant]

Thanks Sathya❤️

[@vishwaschavan7182]

nice way of expanding our learning curve. Thanks for sharing

[@Innozant]

Thanks Vishwas..God bless you dear❤️

[@thangaveluraj5366]

Yeah true..

[@manojkumarsingh3385]

Sir you are great 🙏🏻🙏🏻🙏🏻🙏🏻

[@Innozant]

Thanks Manoj Ji ❤️

[@kishorpanara4191]

Mere pass aap ke liye tarif ke word nahi bus Thank you sir again Thank you sir

[@Innozant]

Thanks Kishor Ji❤️

[@satishchaurasia84ya]

Wow Boss. I salut you. Always show mind blowing questions and answer. Way of teaching is Marvellous.

[@Innozant]

Thanks dear..God bless you❤️❤️

[@mganas9381]

Very new questions I have no ideas Wonderful

[@Innozant]

Thanks dear❤️

[@krishankant4705]

Owsome video and all contants great 🔥👍 bro mai bahut se video lagatar dekh liya hun ab bari h practice ki ty so much😁

[@Innozant]

Thanks Krishan Ji ❤️

[@vijaysahal4556]

Amazing sir 👍🏻👍🏻👍🏻

[@Innozant]

Thanks Vijay Ji .❤️❤️❤️

[@paras5861]

Guruji ❤️

[@superNareshg]

Thank you sir 🙏

[@Innozant]

Thanks dear❤️

[@iccstudio1106]

Wha Sir maan gye apko 👍🙏🙏

[@Innozant]

❤️❤️

[@thangaveluraj5366]

Excellent, I would request you to Do VBA stuff exhaustively, for all.. beginner to pro

[@Innozant]

Thanks..Yes after BI series will start VBA as well .

[@mishradeepak54]

Fine 👌

[@ankitjindaljulana]

Thank you sir

[@Innozant]

Thanks dear❤️

[@sawaimalhi8439]

First comment

[@sekhar6106]

Sir, Thank you for explaining various ways to solve a question by using COUNTIF formula. To be frank, I have no knowledge about the formulas explained. Will practice and try to understand applying {} in some formulas.

[@Innozant]

Ok..Kindly proceed with Basic Excel statistical function playlist to understand these concepts

[@GaganDeep-rx5zx]

Nice sir

[@Innozant]

Thanks Gagan❤️❤️

[@AkashBravia]

I knew only 9 oit of 10 but now i know all the solutions and the credit goes to yoi sir.

[@Innozant]

Keep learning

[@jayantabhattacharyya628]

Dear Sir Excellent Countif Maharaj video. I have the answers of all 10 questions except question no 5 & 9 I don't know. It would be very helpful for me in near future. One more request, if possible, kindly upload videos on computer hardware courses. It is equally necessary. Thanks & Regards Jayanta Bhattacharyya

[@Innozant]

Thanks Jayanta..Happy learning ❤️

[@Crocodile_Gaming.2002]

Me also solve same question

[@arunsandhu3087]

Waiting for jata dhari new episode 😄😆😁

[@pawankumardk9399]

Love you 😘

[@Innozant]

Thanks Pawan..God Bless You..Gn

[@ubaidillahmuhammad20]

loved it

[@Innozant]

Thanks dear

[@parthahati2284]

Thanks for bringing this kind questions in front of us.. I knew only 4 of 10 . But now I believe I can solve all type of countif questions 🙏🙏🙏🙏

[@Innozant]

Thanks Partha.Happy Learning ❤️

[@parthahati2284]

@@Innozant sir the way teach us, I just can't skip your single post . Lucky to have you as my teacher ❤

[@rajivranjan-mf6zu]

Gud Evening Sir... i had no idea this type of count can be also happened....all 10 question is new for me thanks for forwarding one step ahead to me honestly you r great sir...thank u♥♥🙏🙏

[@Innozant]

Thanks Rajiv Ji .Hope you enjoy these questions..Happy learning ❤️❤️

[@RahulRoy-po9ct]

🙏

[@tejpalsain1507]

सर 4 क्वेश्चन नही आये, उनका कोई आईडिया नही था। थैंक्यू काउंट को एडवांस लेवल व अच्छे से समझाने के लिये।

[@Innozant]

Thanks Tejpal Ji .Happy Learning dear❤️❤️

[@jitendradore9529]

Sir me aapke sare video dekhta hu. Bahut hi achcha knowledge dete ho. Mera 1 question hai ki agar students ki list di ho or un students ka data bhi nikalna ho jo kuch subjects me fail ho gaye ho magar kuch me unke bahut achche marks ho to is condition me wo pass to nahi hai. Fir percent ke hisab se kaise unhe pass kiya ja sakta hai. Example ke liye x student hai. Jise marks mils English 67/100 Hindi 89/100 Science 50/100 So. Science 23/100 Maths 78/100 Is condition me agar sum kar ke percent nikale to wo pass hai magar actual me wo so. Science me fail ho gaya isliye wo fail hoga. Please mujhe suitable answer de.

[@Innozant]

Sheet share kriye aise explain karna to bht muskil h comment me

[@aqeelahmadengr3]

Sir, aik month ki list hai 744 value hain. Time 1700 say 2100 tk har din ki 5 hour ki average kaisay karain.

[@ramandeep14590]

1.no 2.no 3.no 4.no 5.no 6.no 7.no 8.no 9.no 10.no I m unable to solve a single question sir.... But thanks for this learning video 🥰🥰🥰solutions are extremely useful😍😍😍

[@Innozant]

Koi baat nhi Raman..Anlb achese practice kar lijiye..bht kaam aayega dear❤️❤️

[@ramandeep14590]

@@Innozant sure sir🥰

[@durgeshrai8938]

Nyc sir

[@Innozant]

Thanks Durgesh Ji

[@shreeram90861]

Sir wating for vba🙏🙏

[@akshaychande980]

Sir, please POWER POINT ka series continue ki jiye...thanks in advance

[@Innozant]

Karte hain start jald

[@vivekkalshan3589]

Sir ye question kal mujhse interview me puccha gya tha

[@Innozant]

Answer kar paye ki nahin?😀

[@vivekkalshan3589]

@@Innozant nahi sir time kam tha or question jyada the isliye nahi kar paya

[@vivekkalshan3589]

Smjh hi nahi aaya

[@mayurjain2003]

Second

[@aghanoorhussain7287]

Sir vlookup w7 w10 main kaam nhy kr raha hai

[@pa2happiness13]

Sir Ms dos Mai ye sb Dir command Kai 7 bataya jata hai

[@Innozant]

❤️

[@abdulghaffarasi6649]

hello sir, i am Abdul Ghaffar from Pakistan. your lectures are very helping. i have a quarry, plz answer it. can we calculate different values written in different colours. for example Red written values total, Green written values toatal?

[@kirkhammet6456]

Sir, 5 different number me se ek number ko chorkar baki 4 numbers ko kese count karega??? Sir, plz reply its very very urgent

[@hafizaudiotv]

Sir mene "09" Questions Solve kiye hy alag method se. Q1 .{=SUMPRODUCT(--(MID(A2:A26,2,1)="a"))} Q2 .{=SUMPRODUCT(--(LEN(A2:A26)-LEN(SUBSTITUTE(A2:A26," ",""))=2))} Q3 .{=SUMPRODUCT(--(LEN(A2:A26)=5))} Q4 .{=SUMPRODUCT(--(LEN(A2:A26)-LEN(SUBSTITUTE(A2:A26," ",""))=1))} Q5 .{=SUMPRODUCT(--(LEN(A2:A26)-LEN(SUBSTITUTE(A2:A26," ",""))=2))} Q6 .{=SUMPRODUCT(--(LEFT(A2:A26,1)="k")*(LEFT(IFERROR(RIGHT(A2:A26,LEN(A2:A26)-FIND(" ",A2:A26)),""),1)="k"))} Q7 .{=SUMPRODUCT(--(RIGHT(IFERROR(LEFT(A2:A26,FIND(" ",A2:A26)-1),""),1)="n")*(RIGHT(A2:A26,1)="n"))} Q8 .{=SUMPRODUCT(--(LEN(A2:A26)-LEN(SUBSTITUTE(A2:A26," ",""))=0))}. Q9 .{=SUMPRODUCT(--(LEFT(A2:A26,1)="A")*(LEFT(IFERROR(RIGHT(A2:A26,LEN(A2:A26)-FIND(" ",A2:A26)),""),1)="n"))} . Please Feed Back Den "Sir" Ye Method Apko Kese Lage 😇

[@pabitrapradhan4356]

starts with k and ends with k count ans is 2

[@ibrahimkvlogs3220]

Sir kya aap Mis ka coaching karate hai mujhe bhi karna hai plz address bata de placements bhi hoga

[@Innozant]

Aap Innozant ke number par whatsapp karle saara detail le sakte hain live classroom training ka.contact details innozant website par available hai

[@ashoksurin5860]

main sirf ek question ka solve kiya tha ... baki sab confused tha

[@hemantsharma2848]

Sir aap jo itne bde formula lagate ho jabki aap jaante ho or fir expect humse karte ho ki aap jaante honge 🤔🤔

[@Innozant]

Hahaha.. Offcourse aap sabse expectations the hoga na .. Concept saara seekhaya hai apko to ❤️❤️😀Happy learning

[@KaranSaim]

Sir I almost understood all questions but I didn't understand this a question =countif(A8:B7,"* * *") Sir this question I didn't understand please make video on this question me.

[@kashisharora4563]

Sir, please tell why you use (1,-1 ) ??

[@Innozant]

Already explained in Excel conceptual playlist Kashish..Kindly learn it step by step from Playlist

[@kashisharora4563]

@@Innozant sir maine dhundi video but I can't find

[@priscilla7578]

When I type formula it shows there's a problem with this formula sir

[@sverma7798]

Total Count (first Name start from K & Last name from k) iska answer sir aapne galat Bataya hain K* K* ki jagah K* *K hoga respected Sir

[@paramjeet975singh3]

Sir special character wala agar list bahut badi ho 1000 rows ho to kaise pata chalega ki kon kon se special character hai... Jaise apne countif( dollar aur stra wala lagaya)..... To hame kaise pata chalega ki kon kon se lagane hai kyoki list bahut badi hau

[@paramjeet975singh3]

Sir??

[@paramjeet975singh3]

Sir??

[@Rajaji9782]

Sir playlist ka kya name h

[@Innozant]

Excel.maharaj

[@vivekkalshan3589]

Or question sir ye tha Ex, Vivek kumar Rahul Singh Naresh kumar Hariom ji Rakesh kumar Or sir total no of count batna tha ki Kumar kitne h

[@Innozant]

Acha...kiye ki nhi ye ques?

[@vivekkalshan3589]

Sir give me answer for this question

[@bhoopendraraghav9781]

I know all

[@Innozant]

Thanks Bhoopendra ji❤️❤️

[@gulshansharma4469]

But questions intresting hai

[@Innozant]

Thanks dear❤️❤️❤️

[@Prudencekill-ls7wc]

Aap nahi bataoge to kon batayega....jb formula use karte ho to concept batao na

[@Innozant]

Dear..concept padha chuka hu advance excel series me..isliye Maharar series me questions piche ja rahe hain ki aap apply kro concept

[@solotravellerAmit]

Nahi Sir

[@Rajaji9782]

Sir aap bataya kro ki kyo * * * diya hm bitch m se video dhekhte h to PTA nhai chalta h😢

[@Innozant]

Watch complete series not random video to understand the concept

[@डकुमेन्टमेरा]

No idea 💡

[@Innozant]

Kindly do your practice ❤️

[@pankajbhadana7341]

Nhi

[@lkumar2727]

Samajh hi nahi aaya khuch bhi explanation bhi karna chaiye tha.. Adhi video par hi chod diya video.

[@Innozant]

Dear L Kumar Ye Excel Maharaj series hai..that means already Basic excel aur advanced excel ke concept seekha chuke hain unke liye hai..isliye main humesha bolta hu ki Course in sequence seekhiye steo by steo feom basic to advanced..Jin student ne padha hai start se unhe kpi issue nhi aa rha hai..main wildcard aur countif ko alreday explore krke pehlw hi padhaya hua hai

[@gulshansharma4469]

Kuchh samjh nahi aaya

[@Innozant]

Basic excel se padhenge to ye saare questions samajh aayega..excel maharaj series expert learner ke loye hai dear jinhone excel concept seekh liya hai unke liye