🔥AVERAGEIFS Formula in Excel AVERAGEIFS in Excel AVERAGEIFS Excel Tutorial Simplilearn

hey everyone welcome to Simply learns
YouTube channel today we will learn
about the average if in Excel that said
if these are the type of videos you'd
like to watch then hit that like And
subscribe buttons and the bell icon to
get notified just for a quick info if
you want to upskill yourself master
business analytics skills and land your
dream job or growing your career then
you must explore simply learns goad of
various business analytics programs
simply learn offers various
certifications and postgraduate programs
in collaboration with some of the
world's leading universities like IIT RI
Purdue and cab through our courses you
will gain knowledge and work ready
expertise in skills like prescriptive
and Predictive Analytics regression
classification and over a dozen others
that's not all you also get the
opportunity to work on multiple projects
and learn from industry experts working
in Top Tire product companies and
academic from top universities after
completing these these courses thousands
of Learners have transitioned into a
business analytics role as a fresher or
moved onto a higher paying job and
profile if you are passionate about
making your career in this field then
make sure to check out the link in the
print comment and description box below
to find a business analytics program
that fits your experience and areas of
interests now without further delay
let's get started with our onepoint
agenda that is average ifs in Excel so
average if is basically an average
function but with an if condition let's
say if you have multiple departments in
your industry or in your office and your
HR asked you to find the average salary
of all the employees who are present in
a certain Department let's say
development team then you might have to
create a new table with all the
employees in the development team and
then find out the average but what if I
say there is one such average formula
which comes with a condition called if
and using a combination of average and
if you can find out that average number
just within a few clicks yeah that's
exactly what we are going to do today so
for that let's get back to Excel
spreadsheet where we have the data set
ready so this is our employee data set
and here we have the same use case we
have a lot of people from a lot of
designations or a lot of departments now
let's try to find out the average salary
of all the employees who are present in
development team so the formula is
really simple equals to average F and
range comma you want the value as to be
present as department so we will be
adding it in between double codes so
development close and get now the salary
range select the salary column press
enter there you go so the average value
of or average salary of the employees
present in development team is around
38333 per or per month if you're
considering this in rupees this could be
per month if you're considering this in
terms of dollars it can be per anal and
that's how you use average F in Excel
and with that we have come to the end of
the session on how to use average F
function in Excel if you have any
queries regarding any of the topics
covered in this session or if you
require the resources like PP or data
set that is used in the session please
let us know in the comment section below
and R of we'll be happy to help you as
soon as possible until next time thank
you for watching and stay tuned for more
from Simply learn staying ahead in your
career requires continuous learning and
upskilling whether you're a student
aiming to learn today's top skills or a
working professional looking to advance
your career we've got you covered
explore our impressive catalog of
certification programs in cuttingedge
domains including data science cloud
computing cyber security AI machine
learning or digital marketing designed
in collaboration with leading
universities and top corporations and
delivered by industry experts choose any
of our programs and set yourself on the
path to Career Success click the link in
the description to know
more hi there if you like this video
subscribe to the simply learn YouTube
channel and click click here to watch
similar videos to ner up and get
certified click
here