DSR Excel Formula that tabulates Across tabs and Feeds into Chart.

I figured it would be easier doing the math from week to week versus a work book with 8 full weeks in it. I may just need both. Regardless, I need to be able to insert a workbook sheet/tab each week that feeds into the report numbers on the DSR tab.

Thanks for taking a look at this. : - ) Any help is much appreciated!

The first tab is the DSR, the daily report I send out.

(C13 on the DSR tab, I haven't created a formula yet, still waiting on team members to give me their final numbers on Blocked Test Cases).

Example: Add values in worksheet tabs 11_11_DSR, 11_12 DSR, 11_13 DSR, 11_14 DSR, 11_15 DSR.

Pass =SUM(C2:C25)

Fail =SUM(D2:D25)

Passed with Observation =SUM(E2:E25)

Blocked =SUM(J2:J25)

What I need is a formula that tabulates the totals for Pass, Fail, Passed with Observation and Blocked on each daily tab for the week and drop those totals into the DSR Tab for respective cells C10-Passed, C11-Passed Observation, C12-Failed, C13-Blocked.

Kind Regards,

Evner: Excel, Databehandling, Visual Basic, Matematik, Dataindførsel

Se mere: excel summary sheet multiple worksheets, how to create a chart from multiple worksheets in excel, combine multiple excel sheets into one sheet, excel line graph from multiple sheets, excel chart data from different workbooks, how to link a graph in excel to another worksheet, how to pull data from multiple worksheets in excel, excel master sheet sub sheets, call web service excel formula, excel formula sheet, microsoft excel formula sheet, check excel formula aspnet, excel formula convert utm latitude, excel formula network address range, excel formula capture data time day, accounting excel formula, excel formula expertise, excel formula doc file, excel formula escrow, excel formula aging report accounting

Om arbejdsgiveren:
( 0 bedømmelser ) Mckinney, United States

Projekt ID: #22380140

Tildelt til:


I have 4 yrs in Programming, Automation & more importantly delivering projects as required & in quick turn around time. I work full time as Freelancer & Blogger. I will be able to start your work immediately. My Main S Flere

$40 USD in 7 dage
(58 bedømmelser)

Hi, hope you are doing good! I have done my MBA from one of the top 3 institutes of India and have completed many jobs in Excel and macros related to the ask here. You can check my jobs history for the same I can ass Flere

$40 USD på 1 dag
(8 bedømmelser)

17 freelancere byder i gennemsnit $124 på dette job


Hi, I am good at Excel Advanced Formulas and VBA macros. I have referred the file. You want to transfer the data and create the summary even with the new sheets coming in? Looking forward to discuss further in detail Flere

$250 USD in 5 dage
(898 bedømmelser)

Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the Flere

$250 USD in 6 dage
(80 bedømmelser)

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$100 USD på 1 dag
(335 bedømmelser)

"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed mor Flere

$140 USD in 7 dage
(246 bedømmelser)

Dear client I am an excel expert and I have previously carried out a number of projects in excel in the past using macros and formulas. I can definitely help you in this project. Kindly contact me. Roy

$100 USD på 1 dag
(350 bedømmelser)

I am MBA accounts and finance, Mphill in computer science and having seven years of experience in Excel (vba & macro's) development. I already done many projects of: • Excel Automation. • Excel Reports system. • Exce Flere

$200 USD på 1 dag
(95 bedømmelser)

$ 30 Only ----- In just 1 Hour ------ Excel VBA Macro Coding, Formula Generation and Automation Expert

$30 USD på 1 dag
(42 bedømmelser)

Hello, i have read the details provided..please contact me to discuss more on the project deadline and some other few things

$150 USD in 7 dage
(21 bedømmelser)

Hi there, I read your requirements and understand very-well and ready to start work from now. Hope you give me a chance to do work with you. I hope you will be kind enough to consider me for your [login to view URL] forw Flere

$94 USD in 5 dage
(6 bedømmelser)

Hello, I'm Russel, I can provide you perfect work as you looking for . we can discuss more in chat . I will be waiting for your response . I have very great experience about your project , if you want discuss more ple Flere

$140 USD in 7 dage
(0 bedømmelser)

"Hi there, I have read your project description carefully and I would like to work with you on this project. I have well experience in data entry work like data copy from the website and make it an excel file. Feel fre Flere

$100 USD in 2 dage
(0 bedømmelser)

Hello Sir, Contact me. I have read your requirements and willing to work for you. My Experties are in MATLAB, EXCEL, Data Entry, Programming and Circuit Designing using Proteus, Etap, Power World Simulator

$140 USD in 7 dage
(1 bedømmelse)

with the growth of my skills in the area i believe my work will not only be good but the best hence no regrets for giving me the chance .Thanks

$140 USD in 7 dage
(0 bedømmelser)

hey, I AM READY TO START WORK NOW! Dear Prospective Client, Believe me, I am the person for this job. I am contacting you for one simple reason - you deserve the very best. I am a versatile and experienced writer with Flere

$140 USD in 7 dage
(0 bedømmelser)

Hi, This is my first time on freelancer, so please excuse me if I am not doing a right proposal. I am used to develop some VBA modules in excel to make operations. It sounds you need a formula as there will be more tab Flere

$60 USD in 4 dage
(0 bedømmelser)