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?
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.
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. 👍
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
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.
The best sumifs video available! Helped me a lot
This was really great, life saver
Hi, Thanks for the lesson.
How do I get this data or similar ones to practice on.
Hello! Just want to ask, how did H5 help you as a criteria? :)
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?
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.
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. 👍
Hello I have a data in two tabs where I have to match codewise how can I pick that?? Would you please help me
This was great, manage to learn in less 20 mins. Thanks
Good lesson and Clearly . Thank you for your teaching :)
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.
Sir, Can you Please provide Practice File
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
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.
hallo sir help me please provide practice file here link?
Can I download this ????
Very Appreciate to your lesson , it helped my work a lot. :) Good luck
Gostei do video.
👍
Excel sheet and formula in the same name makes me confusing terribly
speak louder and clearer would be a good
You should slow down your steps- way to fast-
Your video is too quiet. Can you not improve on the sound?
Way to fast for me.