true

Learn Microsoft Excel Training from the Best Tutors

Affordable fees
1-1 or Group class
Flexible Timings
Verified Tutors

Search in

HERE TODAY WE WILL USE THE SUMIF FUNCTION

13/09/2019 0 0

A	B	C
1	PRODUCT NAME	TOTAL AMOUNT
2	WASHING MACHINE	3616
3	MI PHONE	4978
4	SAMSUNG MOBILE	3825
5	NOKIA PHONE	3902
6	T.V	3759
6	L.G REFRIGERATOR	3693
7	BOTTLE	4191

	=SUMIF(RANGE, CRITERIA,[SUM RANGE ]	=SUMIF(B2: B7,B3,C2:C7)
`ANSWER	MI PHONE	3616

0 Like 0 Dislike

Follow 1

Other Lessons for You

Pivot table - Transform numbers in calculated field

How to convert the absolute numbers in pivot table into Lakhs, Millions, Trillions without adding a spare column in the data source. Name the field in the Calculated field and apply the formula by Double-clicking...

Phanitha P.

0 0

My Experience on Recruitment for Data Analyst role.

Hi All, I want to share my experience here and why I chose to take up classes on Advanced excel. This is not technical lesson but a motivation to improve your skills. I was leading Data Analyst team...

Sai Krishna

0 0

Use of Indirect Function

I would like to share my experience of how Indirect formula helped me in my recent project. I was working with some report which was connected to a large database in excel, so whatever changes I made to...

Kaustubh Chavan

0 0

How to install Analysis ToolPak in Excel

The Analysis ToolPak is an Excel add-in program that provides data analysis tools for financial, statistical and engineering data analysis. To load the Analysis ToolPak add-in, execute the following steps. 1....

Dheeraj Kushwaha

1 0

Shortcut for adding big data or Columns in MS excel

1. Simply click on the next cell of column where you want the sum. 2. Press Alt and = keys together. 3. It will show the sum and range of sum. 4 Click Enter key and you will get sum of the column.

Kimsi J.

0 0

Find Microsoft Excel Training classes near you

Looking for Microsoft Excel Training classes?

Learn from Best Tutors on UrbanPro.

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you

Microsoft Excel Training Questions

Can a person learn advanced level MS Excel through YouTube videos?

7 Answers

What is shortcut to rename the spreadsheet name?

34 Answers

How many days it will take to complete advance excel course?

12 Answers

Dear sir,how to convert number to text in excel by formula?

8 Answers

What is the use of Data validation commond. can you demonstare the example in common life?

5 Answers

Looking for Microsoft Excel Training Classes?

The best tutors for Microsoft Excel Training Classes are on UrbanPro

Select the best Tutor
Book & Attend a Free Demo
Pay and start Learning

Learn Microsoft Excel Training with the Best Tutors

The best Tutors for Microsoft Excel Training Classes are on UrbanPro

I am a Student I am a Tutor
Name*	Please enter your full name. Please enter institute name.
Email*	Please enter your email address.
Phone*	Please enter a valid phone number.
Location*	Please enter a pincode or area name.
City*	Please enter city name.
Category*	Please enter category.
Gender*	Male Female Please select your gender.
Email ID/ Mobile No.*	Please enter either mobile no. or email.
Enter Password*	Please enter OTP Please enter Password Sorry, this phone number is not verified, Please login with your email Id.