MS Excel 2007 [Uses of AVERAGE, AVERAGEA. AVERAGEIF, AVERAGEIFS Function] | ICTC-Monteswar | Bengali
Today I discuss Microsoft Office Excel 2007 in details [Uses of AVERAGE, AVERAGEA, AVERAGEIF, AVERAGEIFS function] in Bengali.
Please see the tutorial from start to end…
AVERAGE is one of the most straightforward and easy-to-use Excel functions, and the following examples prove this.
AVERAGE(number1, [number2], …)
The AVERAGEA function is similar to Excel AVERAGE in that it calculates the average (arithmetic mean) of the values in its arguments. The difference is that AVERAGEA includes all non-empty cells in a calculation, whether they contains numbers, text, Boolean values of TRUE and FALSE, and empty strings returned by other formulas.
AVERAGEA(value1, [value2], …)
Value1, value2, … are values, arrays, cell references or ranges that you want to average. The first argument is required, others (up to 255) are optional.
The AVERAGEIF function in Excel calculates the average (arithmetic mean) of all the cells that meet a specified criteria.
AVERAGEIF(range, criteria, [average_range])
The AVERAGEIFS function has the following arguments, the first 2 are required, the last one is optional:
• Range - the range of cells to be tested against the given criteria.
• Criteria - the condition used to determine which cells to average. The criteria can be supplied in the form of a number, logical expression, text value, or cell reference.
• Average_range - the cells you actually want to average (optional). If omitted, the formula will calculate an average of the values in the range argument.
The AVERAGEIF function is available in Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010 and 2007.
The AVERAGEIFS function in Excel is a plural counterpart of AVERAGEIF. It allows for multiple conditions and returns the average (arithmetic mean) of cells that meet all of the specified criteria.
AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)
The AVERAGEIFS function has the following arguments:
• Average_range - the range of cells that you want to average.
• Criteria_range1, criteria_range2, … - 1 to 127 ranges to be tested against the specified criteria. Criteria_range1 is required, subsequent ones are optional.
• Criteria1, criteria2, … - 1 to 127 criteria that determine which cells to average. The criteria can be supplied in the form of a number, logical expression, text value, or cell reference. Criteria1 is required, additional criteria are optional.
The AVERAGEIFS function is available in Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010 and 2007.
Welcome to the Official YouTube channel of Ideal Computer Training Centre (ICTC) ....
IDEAL COMPUTER TRAINING CENTRE (Govt. Regd.)
(Address - MONTESWAR, HOSPITAL ROAD, PURBA BARDHAMAN, 713145)
Director & Administrator - NIHAR RANJAN BANDYOPADHYAY
(M.Sc, MCA, MLIS, D. El. Ed, B.Ed)
Contact us on
Official Facebook Group Link
https://www.facebook.com/groups/70219...
Official Facebook Page Link
/ ideal-computer-training-centre-monteswar-1...
Instagram Link
/ ictc.monteswar
Emails - [email protected]
[email protected]
Mobile - 9732048319 & 8250718665
Today's Topic – Microsoft Office Excel 2007 in details [Uses of AVERAGE, AVERAGEA, AVERAGEIF, AVERAGEIFS function] in Bengali.
Created by - Nihar Ranjan Bandyopadhyay
Captured by - Saikat Kundu & Dolan Kundu
Special thanks - Saikat Roy
Microsoft Office Word Full Playlist Link
• Microsoft Office Word 2003 Full Tutorial (...
Wordpad Full Playlist Link
• WORDPAD FULL TUTORIAL IN BENGALI
Notepad Full Playlist Link
• Notepad Tutorial in Bengali
Microsoft Office Excel 2007 (Basic Level) Full Playlist Link
• Microsoft Office Excel 2007 Tutorial (Basi...
Microsoft Office Excel (Advance Level) Full Playlist Link
• Microsoft Office Excel Tutorial (Advance L...
© Ideal Computer Training Centre
(All the copyrights of this tutorial are owned by the officials of Ideal Computer Training Centre. Without permissions this video/audio should not be re-uploaded on any social media platforms)
["Copyright Disclaimer under section 107 of the Copyright Act of 1976, allowance is made for “fair use” for purposes such as criticism, comment, news reporting, teaching, scholarship, education and research. Fair use is a use permitted by copyright statute that might otherwise be infringing.”]
#MSEXCEL#BANGLACOMPUTERTUTORIAL #ICTC