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

Flash Fill: Advance Excel

Flash Fill is only available in MS excel 13 and above versions. Flash fill is used to fill the data automatically in the below cells if a pattern is evident. It can also extract, insert or concatenate. Some...

Trisha J.

0 1

Benefits Of E-Learning

From an organizational point of view, e-learning courses can be conducted by trainers in one location and it can benefit employees across continents in different time zones. This can bring down training...

Edusmart Skills

0 0

Common MS Excel Shortcuts to make life easier!

Hi All,I am new to UrbanPro with a passion for learning and teaching analytical tools, MS Excel being the one of them. Excel is one of those master tools which seems untapped to its fullest potential;...

Shruti S.

0 0

For the Best Training You Need the Best Trainer

Microsoft Excel Beginner, Intermediate and Advanced course will provide a core understanding of how to effectively operate and use the Excel spreadsheet software at an advanced level to learners. Microsoft...

Prasad

0 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

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

Make A Excel Software Challenge: To Track Time Records To Enhance Daily Output Of Staff

7 Answers

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

19 Answers

What is shortcut to rename the spreadsheet name?

34 Answers

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

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