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 View Comments

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

Shortcut of Excel for Selection

Select the whole column: CTRL + SPACE Select the whole row: SHIFT + SPACE Select table: SHIFT + CTRL + SPACE bar Select visible cells only: ALT + ; Select entire region: CTRL + A Select range from...

Shashank Maheshwari

1 0

How to create drop down function in Excel?

Many times while working you would require to create drop down values in excel. Many people get stuck at this point and think it is very difficult to create dropdowns or maybe macro is required to create...

Ayush Agarwal

1 0

How Lookup function to replace Nested If statement

Nested If statements are complicated to type down and include many parameters. The best method to replace them is to use the lookup function. Using the lookup function shortens the formula at a considerable...

Kaustubh Chavan

0 0

Vlookup is old, use Index Match function

Vlookup function has the below limitations. 1. The lookup range should always be on the right-hand side of the vlookup value. This is the biggest limitation. 2. If supposedly you need to look up a value...

Ayush Agarwal

0 0

Hidden Gems Of MS Excel - Consolidate

Situation: You are part of the Finance Team, and work at Headquarters of an Organization.Periodically, You receive expense data from Teams in different Regions.After You receive expense data, You SUM all...

Ankur Sharma

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

What is shortcut to rename the spreadsheet name?

34 Answers

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

11 Answers

Is learning Tally good or is learning Advanced Excel and Python good? Which one will be better for getting...

19 Answers

Can you make a Software Base On Excel, that records Automatic Billing Information Just Like A POS System. ...

9 Answers

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

8 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

Migrate

Class

Subject

Chapter

Migrate to

Concept Solution

Migration Successful

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.