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

Hidden Gems of MS Excel - New Window

You are working on 2 Worksheets in Same Workbook. To complete Your task, You have to frequently navigate between the Worksheets.Understandably, to frequently navigate between the Worksheets is inconvenient,...

Ankur Sharma

2 0

Top 30 formulas in Excel

Generally, we are only use maximum "30 formulas" in our day to day routine. let's explore with below formulas and let me know which one is your favorite. Vlookup If Iferror Sum Count Sumif Countif CountA Index Match Left Right Mid Tri...

Vikas Chauhan

0 0

Learning Pivot Table Part-1

You all must have watched movie based on War. One thing you all might have noticed, in most of the movies, armies fought with their enemies hiding inside the bunkers, an army fighting war in open obviously...

Kaustubh Chavan

1 0

Advanced Excel and VBA concept

In this video, learn about Advanced Excel: - Data Input and Hidden Features, - Worksheet Navigation, - Excel Formulas & Functions, - Data Cleaning and Formatting. VBA and its useful Built-in Functions,...

Nagadarshan

0 0

Shortcut for adding big data or Columns in MS excel

1. Simply click on the next cell of column where you want the sum. 2. Press Alt and = keys together. 3. It will show the sum and range of sum. 4 Click Enter key and you will get sum of the column.

Kimsi J.

0 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

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

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

11 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

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.