Statistics for Data Science 1 - W2_T3: SUMIF in google sheets

Welcome to the Week 2 Tutorial of the course "Statistics for Data Science - I" by Prof. Andrew Thangaraj. Full Course: https://study.iitm.ac.in/ds/course_pages/BSMA1002.html Video Overview In this tutorial, we learn how to use the SUMIF function in Google Sheets to calculate sums based on specific criteria. The session explains the syntax of the function, how to define criteria ranges, and how to apply conditions effectively. Through practical examples, you’ll see how to sum values based on text matches (for instance, “stationery”) and numerical conditions (such as quantity greater than 1). These techniques are essential for handling large datasets, automating calculations, and deriving meaningful insights efficiently. About IIT Madras' online Bachelor of Science programme IIT Madras offers four-year BS programmes that aim to provide quality education to all, irrespective of age, educational background, or location. The BS programme has multiple levels, which provide flexibility to students to exit at any of these levels. Depending on the courses completed and credits earned, the learner can receive a Foundation Certificate from IITM CODE (Centre for Outreach and Digital Education), Diploma(s) from IIT Madras, or BSc/BS Degrees from IIT Madras. For more details, Visit: https://www.iitm.ac.in/academics/study-at-iitm/non-campus-bs-programmes #GoogleSheets #Sumif #Spreadsheet #Tutorial #Statistics #DataAnalysis #Function #Formula #Criteria #Summing #Productivity #Excel #Spreadsheet #IITMadras #OnlineLearning #BSProgramme #Education #StatisticsForDataScience #DataScience