#1
|
|||
|
|||
formula needed to sum weeknum results from multiple worksheets
I have workbook of income received from clients. Each worksheet is a separate client and the last sheet is YTD summary. I am trying to create a formula in YTD worksheet that sums the weekly totals from all the clients worksheet.(See attached)
I have created named tables for each client's worksheet and each column has named ranges to help create formulas. For each worksheet I also created a column for weeknum referencing from the date so I can then have their weekly total. I now want to take the results of all of the weekly and monthly totals and sum them into the YTD summary table. Some clients, there will be several entries a week other clients there will be weeks between jobs so each row is not necessarily the next week. As there already is a sumif formula in the cells that have the clients weekly total it makes it hard to work out how to write the new formula for YTD weekly total. I don't want to use grouped data or pivot tables I just want a formula for the YTD summary. I guess similar to the formulas in weekly and monthly total for each client. Any help with this formula would be appreciated. I am thinking that the formula would be something like this: but I know that this is wrong, please help IF FORMULA Logical Test:EFY_SUMMARY[[#This Row],[WEEK NUM]]<>E3 If Value is TRUE: SUMIF(E:E,LISA_INCOME[[#This Row],[WEEK NUM]],B:B) AND If value is TRUE: (E:E,JANEEN_INCOME[[#This Row],[WEEK NUM]],B:B) If Value is FALSE: "" Last edited by JOJO101; 06-28-2015 at 12:45 AM. Reason: added a trial formula |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Summing data from multiple worksheets in a workbook and placing into another worksheet | safrac | Excel | 17 | 10-04-2022 12:21 PM |
Combine or merge multiple worksheets into one worksheet | timomaha | Excel | 1 | 07-21-2014 01:02 PM |
Multiple Dynamic Worksheets Consolidated into One Static Worksheet | mars1886 | Excel Programming | 3 | 02-09-2014 12:50 AM |
Sum multiple worksheets and summary tab that would sum and count by rep name | angie.chang | Excel | 1 | 05-16-2013 12:36 AM |
Bookmarking Formula Results | Wyskers | Word | 3 | 11-09-2012 01:13 PM |