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

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

Datedif() Function

Purpose: This function calculates difference between two dates. it can show the result in days, months and years. Syntax: =datedif(start_date,end_date,"unit") start_date This is earliest...

Saburudeen MA

0 0

Hidden Gems of MS Excel - Find Unique Records using Advance Filter

Want to find UNIQUE Values in a Dataset/Range? By using an Option that is Flexible and Quick. You should find the Advance Filter option helpful. Q) But, Advance Filter is used for filter-ing?A)...

Ankur Sharma

1 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

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

Practical use of Two way Look-up (Category: Advanced Excel)

///////////////////////////////////////////////////////////////

Rakesh Pradhan

0 1

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

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

11 Answers

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

5 Answers

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

9 Answers

Excel formulas in advance level?

39 Answers

What is shortcut to rename the spreadsheet name?

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