MS Excel 2007 [Different types of SUMIF Function] | Part - 2 | ICTC - Monteswar (Govt Reg) | Bengali
Today I discuss Microsoft Office Excel 2007 in details [Different types of SUMIF Function (Part – 2)] in Bengali.
Please see the tutorial from start to end…
The SUMIFS function, one of the math and trig functions, adds all of its arguments that meet multiple criteria. For example, you would use SUMIFS to sum the number of retailers in the country who (1) reside in a single zip code and (2) whose profits exceed a specific dollar value.
SUMIF Function
The SUMIF function is a premade function in Excel, which calculates the sum of values in a range based on a true or false condition.
It is typed =SUMIF:
=SUMIF(range, criteria, [sum_range])
=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
The condition is referred to as criteria, which can check things like:
• If a number is greater than another number
• If a number is smaller than another number
• If a number or text is equal to something
The [sum_range] is the range where the function calculates the sum.
Note: The [sum_range] is optional.
If not specified, the function calculates the sum of the same range as the condition.
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
Official Telegram Link
https://t.me/+4Oyromc0znBiZjc1
Emails - [email protected]
[email protected]
Mobile - 9732048319 & 8250718665
Today's Topic – Microsoft Office Excel 2007 in details [Different types of SUMIF Function (Part – 2)] 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