Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-27-2015, 11:06 PM
JOJO101 JOJO101 is offline formula needed to sum weeknum results from multiple worksheets Windows 7 32bit formula needed to sum weeknum results from multiple worksheets Office 2007
Novice
formula needed to sum weeknum results from multiple worksheets
 
Join Date: Jun 2014
Posts: 2
JOJO101 is on a distinguished road
Default 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: ""
Attached Files
File Type: xlsx 2016FY CLIENT INCOME TRIAL.xlsx (28.6 KB, 16 views)

Last edited by JOJO101; 06-28-2015 at 12:45 AM. Reason: added a trial formula
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
formula needed to sum weeknum results from multiple worksheets 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
formula needed to sum weeknum results from multiple worksheets Multiple Dynamic Worksheets Consolidated into One Static Worksheet mars1886 Excel Programming 3 02-09-2014 12:50 AM
formula needed to sum weeknum results from multiple worksheets Sum multiple worksheets and summary tab that would sum and count by rep name angie.chang Excel 1 05-16-2013 12:36 AM
formula needed to sum weeknum results from multiple worksheets Bookmarking Formula Results Wyskers Word 3 11-09-2012 01:13 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:02 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft