Microsoft Excel 2013 - Using the SUMIFS function across multiple worksheets

This video demonstrates using Microsoft Excel’s SUMIFS function to total up a range of cells across multiple worksheets based multiple criteria ranges / criteria.
This video was created by Optimum - the IT Training Consultancy.
For more information on our Microsoft Office training courses provided in central London, UK - please click here: www.optimum.co.uk/microsoft-of...

[@Abysswalker7]

The best sumifs video available! Helped me a lot

[@michaelmark788]

Good lesson and Clearly . Thank you for your teaching :)

[@bayandonoigantuul6381]

Very Appreciate to your lesson , it helped my work a lot. :) Good luck

[@leanneparkes1079]

This was great, manage to learn in less 20 mins. Thanks

[@neethaap-hn7or]

This was really great, life saver

[@perfectamoruwa9825]

Hi, Thanks for the lesson. How do I get this data or similar ones to practice on.

[@rebekahwolfe92]

I have a monthly point accumulation for multiple people on a list. each sheet lists that monthly total for each person. I want to add a summary sheet which would automatically calculate the running total for each person's points for the year. any suggestions?

[@artistdennisreantaso4380]

Hello! Just want to ask, how did H5 help you as a criteria? :)

[@actwellC.]

Gostei do video.

[@tashishkumarpatro4520]

Is it possible to have a total column after the Qtr4 and sum all the Qtr numbers in one column. The total column should be a sum of all the numbers from Individual quarter sheets based on the criteria

[@OptimumERP]

Hi there! Using the 'SUMIFS + INDIRECT' worksheet, for example, do this: Insert a column between the 'ON-LINE' and 'RETAIL' tables In cell G7 (row 7 is the 'Beverages' row) create a formula that will total the 'Beverages' data to the left - the 4 cells for QTR 1 through QTR 4 The formula would be =SUM(C7:F7) Do something similar for the 'RETAIL' table to the right. Hope that helps.

[@rsn29sep]

i want the same data but from Multiple workbooks which are further categorised month wise, the problem which i'm getting, as soon as close the monthfile, got #Value error instead of Data. please help me would be great for me.

[@OptimumERP]

Hi! I’ve been meaning to get around to achieving a similar result using SUMPRODUCT, but just haven’t had time. Until that happens, take a look at these resources: exceljet.net/excel-functions/excel-sumproduct-function Or this from excelforum: www.excelforum.com/excel-formulas-and-functions/558587-sumproduct-for-multiple-workbooks.html Hope that helps. 👍

[@shivay2049]

Hello I have a data in two tabs where I have to match codewise how can I pick that?? Would you please help me

[@contactauditssss6122]

Sir, Can you Please provide Practice File

[@RunwayCats]

Can I download this ????

[@amarpawar4113]

we want this data set spreadsheet files for practice for us.. please upload this excel data se file in discription for us in Downlod by G-Drive way.

[@muhammadrizkipratama6023]

hallo sir help me please provide practice file here link?

[@dudeyme3331]

👍

[@xviiviiixiv]

speak louder and clearer would be a good

[@kishnura13]

Excel sheet and formula in the same name makes me confusing terribly

[@connorcharamella4049]

Way to fast for me.

[@johnherrewyn4883]

You should slow down your steps- way to fast-

[@kimyenchu]

Your video is too quiet. Can you not improve on the sound?