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

Some Excel Functions

You need to know about these following functions which are based on Microsoft Excel 2010.1. Speedily Move and Copy Data in Cells:-If you want to move one column of data in a spreadsheet, the fast way...

ICreative Solution

0 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

MS Excel: Formulas and Functions: Listed by Category

MS Excel: Formulas and Functions: Listed by Category Worksheet formulas are built-in functions that are entered as part of a formula in a cell. These are the most basic functions used when learning Excel....

Siddhartha Mahapatra

0 0

Data Validation In Excel

MS Excel data validation feature allows you to set up certain rules that dictate what can be entered into a cell. For example, you may want to limit data entry in a particular cell to whole numbers between...

ITech Analytic Solutions

0 0

Conditional formatting with formulas

Conditional formatting quickly formats information in a spreadsheet. But sometimes the biult in rules are not enough. Adding your own formula to a conditional formatting rule gives it a power to help you do custom things.

Sharad Singh

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

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

11 Answers

can i teach

35 Answers

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

8 Answers

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

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