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.
Passed with Observation =SUM(E2:E25)
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.
17 freelancere byder i gennemsnit $124 på dette job
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
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