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 SUMPRODUCT FUNCTION

13/09/2019 1 0

	A	B	C	D	E
1	SR.NO	NAME	SERIES _1	SERIES_2	TOTAL AMOUNT
2	1	VEERU	2	2	4	=sumproduct(D2,E2)
3	2	MAHIPAL	4	6	24	=sumproduct(D3,E3)
4	3	NIHSA	6	8	48	=sumproduct(D4,E4)
5	4	UMA	10	2	20	=sumproduct(D5,E5)
6	5	SHANKER	12	3	36	=sumproduct(D6,E6)
7	6	MAHESH	7	3	21	=sumproduct(D7,E7)
8	7	KAPIL	8	2	16	=sumproduct(D8,E8)
			=SUMPRODUCT(array 1, array 2, array 3 ....)

1 Like 0 Dislike

Follow 2

Other Lessons for You

Tips - How to put PivotTable Field List back at its Original Position?

Have You ever struggled to put PivotTable Field List back at its Original Position?*Original Position - right-side of the worksheet, as highlighted in the following picture: If Your answer is Yes, You...

Ankur Sharma

2 0

How to do Advanced filter in Excel

Ujjal Goswami

0 0

Excel Tip: Calculation of Overall Rating in Excel

Nowadays rating got high importance everywhere. Whether you want to purchase an AC or a toy first we will check for rating of that product. Even before joining any institute we will review the rating then...

Naga Satyanarayana Anantapalli

1 0

Data Analysis with MS Excel Filter - Top Performers, Bottom Performers, Above Average Performers, Below Average Performers!

In the following, You would find lesser-known, unexplored yet Powerful Features of Filter. Please refer to sample dataset below: To do Data Analysis:Step 1) Apply Filter on the dataset.Step 2) In Sales...

Ankur Sharma

1 0

Formula to Populate Weekdays of a Given Month

If you want to populate weekdays (Monday to Friday) in a range, follow below steps. Step1: In Cell A1 write any month 1st date. Let’s say 02/01/2017 (Feb 1st 2017) Step2: In Cell C1 write this...

Karthik Dale

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

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

7 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

What is shortcut to rename the spreadsheet name?

34 Answers

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

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