Statistical Function : Average , AverageA , AverageIF , AverageIFS in Excel

Подписаться 153 тыс.

Просмотров 87 тыс.

50% 1

Learn how to use statistical function in excel using example and explanation
1. Average function in excel
2. AverageA function in excel
3. AverageIF function in excel
4. Averageifs function in excel
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
Playlist Folder-Basic Excel-Statistical Function-average.xlsx)
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#averageifs#averagefunction#Innozant #exceltipsandtricks

Опубликовано:

8 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 147

@anupagarwal8347 3 года назад

I really enjoy your classes....informative, great learning, practical and well presented.

@Innozant 3 года назад

Thanks Anup ji.Happpy Learning

@tech_sultanpur 3 года назад

Sir You are Great Teacher .... Your all Videos is Mind-blowing .. Your Teaching Style is Awesome

@Innozant 3 года назад

Thanks Ahsan Ansari Sahab for such a wonderful and valuable feedback ♥️🙏

@fuadananda9139 Месяц назад

thanks al lot sir

@mahi0417 2 года назад

Thank u so much for your enormous efforts and making the things so simple

@Innozant 2 года назад

Thanks Mahi for your valuable appreciation. Really means a lot to me ❤️❤️❤️

@tikeshwarsahu3082 2 года назад

Thank you sir

@Rajput.Brand_ 3 года назад

❤️❤️ Thanku so much sir itne acche se sikhane k liye ❤️❤️

@Innozant 3 года назад

Thanks Mohit Ji.. Happy learning dear

@golubro9517 2 года назад

Great Sir Aise Hi Koi Samjhaye To Time Nhi Lagta Sikhne Mein..

@Innozant 2 года назад

Thanks dear

@sandeepaswal8944 4 года назад

प्रणाम सर जी | सर आपने Statistical Function बहुत अच्छे से समझाया | AVERAGEA Function मैने आज नया सिखा धन्यवाद सर जी |

@Innozant 4 года назад

Good . Happy Learning dear and share with your friends

@MustafaRaza14 Год назад

Excellent way of teaching🥰

@ajaykumarjaiswal471 8 месяцев назад

Awesome

@madhamanish8959 2 года назад

Thank you sir Very helpful

@anshulmahajan3745 Год назад

thanks aaj mera excel ka practical hai kafi help mili

@Innozant Год назад

Best of luck 👍

@onesidelax7807 Год назад

Great information sir tq

@sawaimalhi8439 3 года назад

bahot he acha samajaya sir aaap nay tu

@Innozant 3 года назад

thanks dear..Kyushu Rhiye aur seekhna Jaari rakhiye

@Vikash_Devrath 3 года назад

Thanks for this video 🔥

@Innozant 3 года назад

Thanks Vikas Ji..Happy Learning dear❤🙏

@anooparora2515 Год назад

Thanks Sir!

@omkarchimbalkar5912 Год назад

Very nice teaching sir ji

@dakshkumar873 2 года назад

Thank you Sir.

@Type-R-Gaming 10 месяцев назад

Thank you sir❤

@thelalit55 2 года назад

Very well explained 👏

@rahulkashyap2704 2 года назад

Amazing guru ji ❤️❣️

@VikramKumar-du2mw 4 года назад

Wow sir 🤩 u r great 👍

@ramkumarchourasia8030 7 месяцев назад

Thnx🙏

@tauziahmed1540 2 года назад

you earned it. Subscribed mate

@Innozant 2 года назад

Thanks for being part of Innozant Family.Happy Learning Tauzi Ahmad Shahab❤️

@rashidiqbal5372 Месяц назад

I want to know the formula for last produced quantity and date of particular product. Can you please tell me?

@chatwithsubhra1 2 года назад

MAst Sir ... Kya baat hain .....

@sourabh5461 3 года назад

Excellent Sir, The way you explained it's seems too good

@Innozant 3 года назад

Thanks dear..Happy learning

@shubhampandey7744 2 года назад

Mzaa aagya sir

@amazingladki Год назад

amazing

@yurialexkov2797 3 года назад

Amazing video

@Innozant 3 года назад

Thanks dear

@aabdullahhaasnain7033 Год назад

Yes boss

@khaboreveryday116 3 года назад

Awsome video

@Innozant 3 года назад

Thanks dear❤️❤️🙏

@gauravbhatia7987 3 года назад

Thnq sir

@Innozant 3 года назад

Thanks Gaurav ♥️🙏

@bhoopendraraghav9781 4 года назад

Very Nice

@Innozant 4 года назад

Thanks Bhoopendra ji..

@waheedhabib5078 Год назад

Sir You are doing amazing but You should focus to zoom in the sheet which will be more visible...

@Innozant Год назад

Thanks Wahid..It was old videos,There is no issue in latest videos

@satishojha6240 4 года назад

Amazing sir good night .

@Innozant 4 года назад

Gm, Thanks satish

@Jian3018 3 года назад

Suppose,the range of average is dynamic and we need to average of a specific range of cells.How will you do then?

@Nawaziishh Год назад

Then select the specific range only

@abhishekchouhan7908 3 года назад

Nice video 👌

@Innozant 3 года назад

Thanks dear..happy learning

@golubro9517 2 года назад

Kasam Se Sir Aapki Class Me Maja Aa Gya 😊

@Innozant 2 года назад

Thanks dear👍❤️

@JyotiSiwach-jk2yp 6 месяцев назад

Teaching method kafi acha tha. Bus dikkat ye thi ke aapne khud ko jyada space diya hua h screen pe.

@Innozant 6 месяцев назад

Video editing me ye issue rha hoga..latest videos me ye issue face nhi kr rhe honge aap

@venugopal7161 2 года назад

Sir, kindly do the Power BI complete course videos.Can you do for us.

@Innozant 2 года назад

Will start this series after a month

@tikeshwarsahu3082 2 года назад

Sir kya conditional formating me whild card use kar sakte h

@rahuljadhav910 2 года назад

Hi Sir...how to find out values from average Average se value kaise nikale

@user-iv2lh7gk1l 8 месяцев назад

AverageIfs functions me Text error resolve kaise kre(Div error).

@waseemjaved1210 5 месяцев назад

3:35 / 12:51 not with 12 bz of text 11

@sandeepchavan455 11 месяцев назад

Can we average the data by different dates

@monikathakur9504 2 года назад

Depth of water nikalni ho to 1 number 0 aye to divide me 1number kam se divide krenge ya nhi

@Unfiltered_ind 2 года назад

Sir excel mei jo bhi excel se related word aate unka Hindi mei matalab kya hota i mean word ko Hindi mei kya kahte hai ex . Summrize, separated,

@vishwanathana2163 2 месяца назад

What if i don't to consider Zero as a value?

@Innozant 2 месяца назад

Where ?

@parthpatel1411 2 года назад

Average of odd number from sr number

@virendrahans2918 Год назад

Sir school ka report card mai 3 term exam. hai Lakin student ek paper mai absent hai to average kaise nikalenge. Please help me as soon as possible Thank you.

@aakankshasrivastava9497 4 года назад

Suprb sir👍

@Innozant 4 года назад

Gm, Thanks

@Innozant 4 года назад

Phir Laptop kharab krke to nhi baith gye hain..It seems again stop practice.😊

@aakankshasrivastava9497 4 года назад

@@Innozant yes facing worst Dell service issue 😏 it been 21 days n still not resolved..Feeling irritated..😣 I m also worried abt my practice..Thanks sir n gud to see, u seem concerned about ur students..

@Innozant 4 года назад

@@aakankshasrivastava9497 Ohh.Call Customer care or send someone to talk with them and resolve whatever issue is asap and need to see you back on track soon.

@aakankshasrivastava9497 4 года назад

@@Innozant I called many times n spent almost 2 3 hrs on customer care call..Talked with tech support executive n his or her manager still...Not getting proper response Pathetic service..😩

@RahulRoy-po9ct 2 года назад

🙏

@gauravpaliwal20 2 года назад

But if multi criteria in same column with another column then it's not work so what the solution example name of person Neeraj And Sohan in same column and second column product name Soap and Shampoo so how to solve

@gauravpaliwal20 2 года назад

please tell me sir

@vikramsingh-mv1ux 6 месяцев назад

SHAANDAR

@pawanwakale8801 3 года назад

Sir in this section while using averageif , output is coming for unit but for sales its showing #DIV/0! . and i am still not cleared in freeze where to use double $ and single $, so pls explain in this comment section.

@pawanwakale8801 3 года назад

and Averageifs me #DIV/0! me error aa raha

@80majak_Vlog 4 года назад

Sir i have one question 1 cell mai 1 se 8 tk ginti h uska sum kese krege

@deepakchauhan4974 3 года назад

sir, I dont know your email id for writing queries and concerns, I have a big concern regarding the downloading files, I am not able to find where are the particular files stored in which file, Lets suppose I want to practice on the date and time function, then I am not able to determine where will i go in your practice download file, .

@Innozant 3 года назад

why you are confused..everything is categorized.. drive.google.com/drive/mobile/folders/1y5h4SMwPLk12xZ2-2U1SDBIQqyH5bz4P/1ip6kBf6ATmuaZOUdC0LfaqTKxpwgEONi?usp=sharing&sort=13&direction=a follow this link..complete basic excel Playlist assignments are there

@mahendrapandey8109 2 года назад

State government GIS calculation ki Excel sheet hai

@nuurpublic8776 2 года назад

Sir ager hamara maal kisi din 100 rupees bik 50 kg kisi din bika 5 kg bika 150 rupees or kisi din bika 100 kg 70 rupees to hame quantity k sath rate ka average kase niklega pure month ka

@AdityaKumar-hm7cb 3 года назад

Dublicat remove krne pr cell bhi remove ho gata hai mgr mujhe remove krne ke dad cell black dekne ke liye kaise dublicat ho remove kr skte hai please sir bata dijiye

@AdityaKumar-hm7cb 3 года назад

Aisa ho skta hai ki nhi

@Innozant 3 года назад

Advance filter se kijiye unique list extract dear

@scrappyboy7214 2 года назад

ture ki value ko 1 kyu leta hai avragA

@virendersroha1754 4 года назад

& iske badle concatenate use kiya kro plz

@Innozant 4 года назад

Kahan lagwa rahe hain concatenate Virender ji..batayen?

@Innozant 4 года назад

Concatenate jab tak likhenge tab tak to & - ampersand se kaam khatam kr denge sir ji..kaam ki productivity badhaiye

@tech_sultanpur 3 года назад

@@Innozant You are Right Sir

@aftaballam3990 3 года назад

Sir ji true likhne par 1 ho gya to ab kitne sankhya me divise karne par ye corect aayega

@Innozant 3 года назад

Kaunse function me Aftab ji?

@aftaballam3990 3 года назад

@@Innozant samgh me agya sair

@aftaballam3990 3 года назад

@@Innozant Excel me formula tab ka ek puri video bnaiye sair Ho sake to ek ek grou ka alag alag video

@marutipatil6399 2 года назад

Wildcards ka imp abhi samaj aaya 😅😅😅

@tausifkhan6048 Год назад

0:26 😂😂😂

@sudheerkumar6757 2 года назад

Sir mujhe. Filter ke video bhej do

@Innozant 2 года назад

Filter ke complete playlist available hain channel par

@wrongturnlima007 3 года назад

sir agar aapke video pehle dekhe hote mere paise barbaad nhi hote

@Innozant 3 года назад

Thanks Dhiraj itna trust show karne ke liye ❤🙏

@wrongturnlima007 3 года назад

@@Innozant sir maine course k liye aapke no pe bhi call kiya tha lekin kisi ne pick nhi kiya

@ctechprime8423 3 года назад

Bhai video zoom karke banaya karo

@Innozant 3 года назад

Ye pehle ke videi hain dear jab itna gyan nhi tha youtube video ka❤️ thanks for suggestions

@RahulYadav-mk8wu 8 месяцев назад

Agape vedeo me Kya batao he use me agreji pad Gaye tum😅😅😂😂

@Priyanshukumar-jp1ei Месяц назад

Sir video dundhula dikh raha hai

@Innozant Месяц назад

Ohh ..

@ronitbro6952 2 года назад

83.84 74.19 55.81 43.97 42.9 27.05 Sir, I have above 6 numbers only in column or row, but I need only those three numbers out of above 6 numbers that give me average of 50 or nearby 50 (+5 or -5) I want those three numbers, highlighted or separated automatically.

@Innozant 2 года назад

Kindly share excel sheet @innozantofficiap telegram id .will see

@muskanmalik4546 11 месяцев назад

Arey sir poori screen pe toh aap hi hai arey sir side mai aao aur distraction kam karo

@bhawnaprajapati8819 3 года назад

Aapne aapko mat dikhaya kro video m....kuch smjh nhi aaya

@Innozant 3 года назад

Dear Bhawna ,Aap khud batayen kinki baat mane,Pehle Sirf Voice over video hi bnate the to student ka dwman aane laga ki sir live video bnayen isse interaction jyada acha rehta hai and I hope ye sahi bhi hai..that's why ab interactive videos banane ki koshish.Aappko yadi kam samajh aaya hai to dubara recap lein video kaa aayega samajh..Don't worry

@bhawnaprajapati8819 3 года назад

Ok sir....vaise aacha smjha rhe ho... Thanku sir ☺️

@Innozant 3 года назад

@@bhawnaprajapati8819 abhi to aapne aagaz kiya hai..Aap Step by step seekhte jayen phir kuch months baad batana aapka experience kaisa rha😀❤️

@bhawnaprajapati8819 3 года назад

@@Innozant sir...you are great...maine ye full video dekhi...or bhoot kuch sikhne ko mila...you are awesome sir... thanks again...m average bilkul aache se sikh gyi☺️☺️

@Innozant 3 года назад

@@bhawnaprajapati8819 Thanks Bhawna.Happy Learning.God Bless You dear

@virendersroha1754 4 года назад

Aaj bhoot late vedio aayi h srji

@kumardilip7217 2 года назад

Video sahi se nhi dikh raha hai

@Innozant 2 года назад

It's showing fine

@koshalmahawar6664 Год назад

pagal insan puri video me to tu hi dhikh rha he , table to dhik hi nhi rhi

@Innozant Год назад

Kitne gajab ke language use Kiya hai aapne Teacher ke liye ,Galti ho gya Koushal sahab aapka kaafi time kharab hua hoga,Aur bht se channel hain jinme excel ke Jadoo wale video mil jayenge,Wahan se seekhen😊 Kaushal sir teacher pagal nahi hai us waqt editing nahi aata tha ,kripya latest video dekhen,aapke ye bhavwa language badal jayenge,😊Thanks for this greate respect.Gid bless You dear ❤️

@Aditya_9696 3 года назад

bhai saab screen dikhao khud ka chehra nahi

@Innozant 3 года назад

Aditya Ji.Thanks for your suggestions.Sayad ye pehla comment aaya hai apke tarafse abtak jisme apko problem ho rahi hai,Dear waise mera koshish sirf content par hi rehta hai,Aisa lag raha hai Innozant family me new member aaye hain aap..Pehle kuch videos dekhiye..Phir feedback jaroor dein.🙏🙂❤️

@Aditya_9696 3 года назад

@@Innozant mujhe jo video dikha uska feedback dunga na. History me thodi jaunga bhai. jab aap screen fully show kroge tabhi log thik se dekh paenge na. abhi mujhe koi value dekhni hai aur beech me aap dikhoge toh it looks weird. aap bottom right me apne aap ko adjust kar skte ho. aur best toh yahi rahega ki aap apni voice use kro bas.

@Innozant 3 года назад

Aditya Ji Sabhi viewers ke view aur mindset alag alag hote hain..Ap ydi mere start ke video dekhen to Sirf voice hi hota tha mera.but viewers ko wo interactive nahi lagta tha tabhi Live aana start kiya main.Anyways thanks for your suggestion,Will keep your words and try to deliver as per audience requirement.Happy Learning.🙏❤️🙂

@vasimuddinsheikh7478 3 года назад

Always try to be polite and respectful to your teacher and second thing he is sharing valuable things with no fee, be thankful for that too..... This is just polite advice don't take me otherwise

@Aditya_9696 3 года назад

@@vasimuddinsheikh7478 I also gave him a polite advice. Read the comment first.