I need to automatically figure some totals on monthly sheets in an excel workbook. Each sheet is a month with groups of data from a work order. Each group has a total. Work order groups are added depending on how many jobs we run each month, so I don;t know how many rows will be in a group or how many groups will be in a month.
I need montly totals to be calculated at the bottom of each sheet. These totals are the SUMs of all the totals from each group of data on the [login to view URL] I need the Monthly Total to find each total in the column and SUM those totals.
Ive attached the excel workbook and a picture trying to help explain. The 2019 workbook is the one I am working on. THe 2014 workbook shows how we used to manually calculate these monthly totals.
13 фрилансеров(-а) в среднем готовы выполнить эту работу за $42
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy
Hi sir, I am specialist to work on spread sheet on excel, quality of work and complete work in time is my priorities. No issue about money. Please come in chat for further guide lines......... Thanks..........
I can make the totals for you. Additionally, I can try and develop a template where you can add in the info and automatically get the monthly totals. If that sounds good to you. Please contact me through Chat.