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 - Consolidate

Situation: You are part of the Finance Team, and work at Headquarters of an Organization.Periodically, You receive expense data from Teams in different Regions.After You receive expense data, You SUM all...

Ankur Sharma

1 0

Excel Tip: Conditional Formatting To Highlight First Value Among Duplicates.

In Column “C”, I have product list and some of them are duplicates. My requirement is to format with background color of green for 1st found value among the duplicates. To solve this, I used...

Karthik Dale

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

Excel Keyboard Shortcuts Daily Usefull Keys

Excel KeyBoard Shortcuts Daily Usefull keys: CLTR A-Z Shift SELECT.ETC ALT All Tool Keys CLTR A Select All Shift+F11 Add New Sheet CLTR C Copy ALT...

Ninety-nine Excel Academy

0 0

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

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

How many days it will take to complete advance excel course?

12 Answers

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

9 Answers

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

8 Answers

Is learning Tally good or is learning Advanced Excel and Python good? Which one will be better for getting...

19 Answers

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

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