Scribd
Upload
25 views1 page

Excel SUM Function Examples and Solutions

Uploaded by

jishnugokul512
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
25 views1 page

Excel SUM Function Examples and Solutions

Uploaded by

jishnugokul512
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Excel SUM Function Practical Problems

Problem Description Formula


Problem 1 You have marks of 10 students in cells A2:A11. Find
Formula:
the total
=SUM(A2:A11)
marks.
Problem 2 Monthly expenses are in B2:B7 (Rent, Food, Travel,
Formula:
Bills, etc.).
=SUM(B2:B7)
Find the total monthly expenses.
Problem 3 Sales data for 5 products are in C2:C6. Find the total
Formula:
sales.=SUM(C2:C6)
Problem 4 You have daily sales for 7 days in D2:D8. Find theFormula:
weekly total.
=SUM(D2:D8)
Problem 5 You have salaries of employees in E2:E20. Find the
Formula:
total salary
=SUM(E2:E20)
expense.
Problem 6 You want to calculate total marks of a student where
Formula:
marks =SUM(F2:H2)
are spread in F2:H2 (Math, Science, English)
Problem 7 Add total sales of two branches. Branch1 sales in Formula:
I2:I10, Branch2
=SUM(I2:I10,J2:J10)
sales in J2:J10.
Problem 8 You want to calculate yearly total sales where monthly
Formula:
sales=SUM(K2:K13)
are in K2:K13.
Problem 9 Find the total stock available from two ranges L2:L15
Formula:
and M2:M15.
=SUM(L2:L15,M2:M15)
Problem 10 Calculate the grand total of marks for 5 students where
Formula:
each=SUM(N2:P6)
student’s marks are in rows N2:P6.

You might also like