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

Hidden Gems Of MS Excel - Track All Comments At Once OR Delete All Comments At Once

*this Article is about Comments in MS Excel, NOT NotesClick here to Learn difference between Comments and Notes You have added many Comments on a Worksheet.Now, You are unable to track All Comments....

Ankur Sharma

2 0

VLOOKUP and LIST Creation Explained

.) This table is in the range A1:D4. You want to find the salary of employee with ID 102. Excel =VLOOKUP(102, A1:D4, 4, FALSE) 102: The Employee ID (your lookup_value). A1:D4: The table containing...

Ganesh S.

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

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

How Lookup function to replace Nested If statement

Nested If statements are complicated to type down and include many parameters. The best method to replace them is to use the lookup function. Using the lookup function shortens the formula at a considerable...

Kaustubh Chavan

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

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

5 Answers

What is shortcut to rename the spreadsheet name?

34 Answers

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

8 Answers

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

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.