Sum and Average in Spreadsheets

Last updated at March 5, 2026 by

Sum and Average in Spreadsheets - Formula [with Examples] - Class 8 - Spreadsheets

part 2 - Sum and Average in Spreadsheets - Spreadsheets - Chapter 5 Class 8 - Tales by Dots and Lines (Ganita Prakash II) - Class 8 (Ganita Prakash - 1, 2 & Old NCERT)
part 3 - Sum and Average in Spreadsheets - Spreadsheets - Chapter 5 Class 8 - Tales by Dots and Lines (Ganita Prakash II) - Class 8 (Ganita Prakash - 1, 2 & Old NCERT) part 4 - Sum and Average in Spreadsheets - Spreadsheets - Chapter 5 Class 8 - Tales by Dots and Lines (Ganita Prakash II) - Class 8 (Ganita Prakash - 1, 2 & Old NCERT)

Remove Ads Share on WhatsApp

Transcript

Sum and Average in SpreadsheetsInstead of using a calculator, we can type a formula into a cell, and the computer does the math instantly. We tell the computer which cells to look at by using a range, written as Start : End - =SUM() adds everything together. =AVERAGE() finds the mean. There are 22 students in the class list. Because Row 1 is used for the header titles, the students' data takes up Rows 2 through 23 Let’s look at some examples We use the same spreadsheet as before Sum of all marks for Farooq is Average Marks scored by Pankaj is Total Marks scored by Ganesh is Average Marks scored in Maths is

CA Maninder Singh's photo - Co-founder, Teachoo

Made by

CA Maninder Singh

CA Maninder Singh is a Chartered Accountant for the past 16 years. He also provides Accounts Tax GST Training in Delhi, Kerala and online.