HERE TODAY WE WILL USE THE SUMIFS FUNCTION.

20/09/2019 0 0

A	B	C	D
1	NAME	PRODUCT NAME	TOTAL AMOUNT
2	SAURABH	WASHING MACHINE	4165
3	MANIPAL	MI PHONE	4803
4	ANJALI	SAMSUNG MOBILE	4610
5	UMA	NOKIA PHONE	4441
6	SHANKER	T.V	3765
7	NARESH	L.G REFRIGERATOR	3773
8	SUNIL	BOTTLE	4554
	=SUMIFS(SUM_RANGE,CRITERIA RANGE_1, CRITERIA1,CRITERIA RANGE 2,CRITERIA 2)	=SUMIFS(D2:D8,B2:B8,B2,C2:C8,C2)
SAURABH	WASHING MACHINE	4165

0 Like 0 Dislike

Follow 1

Other Lessons for You

Advanced Excel - Excel What-If Analysis Goal Seek !

Amey Vidvans

0 0

Why Option Explicit is Required in the VBA Editor

Hi Folks,Do you know Excel VBA Editor has functionality where you don't need to declare a variable in memory (DIM).But what will happen if you write a program without declaring a variable nothing happens?Then...

Kumar S

0 0

Benefits Of E-Learning

From an organizational point of view, e-learning courses can be conducted by trainers in one location and it can benefit employees across continents in different time zones. This can bring down training...

Edusmart Skills

0 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

Hidden Gems Of MS Excel - Sort (add Multiple Levels to Sort Data)

Please refer following dataset: You would know:- To Sort Month from Oldest → Newest OR Newest → OldestOR- To Sort Region from A → Z OR Z → AOR- To Sort Units Sold from Smallest →...

Ankur Sharma

2 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

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

12 Answers

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

7 Answers

What is shortcut to rename the spreadsheet name?

34 Answers

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

5 Answers

Excel formulas in advance level?

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