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

Flash Fill: Advance Excel

Flash Fill is only available in MS excel 13 and above versions. Flash fill is used to fill the data automatically in the below cells if a pattern is evident. It can also extract, insert or concatenate. Some...

Trisha J.

0 1

Data Analysis with MS Excel Filter - Top Performers, Bottom Performers, Above Average Performers, Below Average Performers!

In the following, You would find lesser-known, unexplored yet Powerful Features of Filter. Please refer to sample dataset below: To do Data Analysis:Step 1) Apply Filter on the dataset.Step 2) In Sales...

Ankur Sharma

1 0

Excel Tip: Conditional Formatting To Highlight First Value Among Duplicates.

In Column “C”, I have product list and some of them are duplicates. My requirement is to format with background color of green for 1st found value among the duplicates. To solve this, I used...

Karthik Dale

0 0

Dget-Extract From A Database A Single Record That Matches The Condition We Specify

Syntax: DGET(Database, Field, Criteria) The DGET function syntax has the following arguments: Database Required: The range of cells that makes up the list or database. A database is a list of related...

Daniel I

1 0

How To Create Cutom List And Its Advantages?

You must have observed when you are typing Month names, Excel suggests the next Month Name. Also, you can drag the cursor using the anchor at the right bottom of cell and the series of month...

Vidyesh

1 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

Excel formulas in advance level?

39 Answers

What is shortcut to rename the spreadsheet name?

34 Answers

Make A Excel Software Challenge: To Track Time Records To Enhance Daily Output Of Staff

7 Answers

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

12 Answers

Hi I want to use conditional formatting for 4 cell and where they have - value too. So, I want anything...

11 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.