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 SUMIFS FUNCTION.

20/09/2019 0 0 View Comments

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

Data Consolidation In Excel

Before you begin consolidating the data, make sure that there is consistency across the data sources. This means that the data is arranged as follows: Each range of data is on a separate worksheet. Each...

Itech Analytic Solutions

0 0

Create a Grading in Excel using Formulas (All versions)

Topic: Applying Grading /Ranking in Excel (All versions Let’s Say you need to rate the Sales with some grade text like POOR, AVERAGE, GOOD and EXCELLENT Based on a range of values as mentioned...

Bhavna Philipose

0 0

Common MS Excel Shortcuts to make life easier!

Hi All,I am new to UrbanPro with a passion for learning and teaching analytical tools, MS Excel being the one of them. Excel is one of those master tools which seems untapped to its fullest potential;...

Shruti S.

0 0

What are the function categories on Excel?

Function Categories There are many categories of functions in Excel. Each category has specific functions that pertain to that category. Financial: Performs common business calculations including accounting...

Talent Hub Training Institute

0 0

Hide Duplicate Values & Apply Borders Using Conditional Formatting

Please refer following screenshots:1st Screenshot: Original Dataset2nd Screenshot: After Conditioinal Formatting is applied In 2nd screenshot, using Conditional Formatting:1) Repeat months are...

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

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

8 Answers

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

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

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