Forum Discussion
Jsbluemoon82
Feb 16, 2020Copper Contributor
Sumifs
Hi I am trying to use SUMIFS to register weekly totals from one worksheet to another... For example, I have one worksheet that I manually enter data on week by week and i would like to automati...
Riny_van_Eekelen
Feb 16, 2020Platinum Contributor
Jsbluemoon82 Your formula in F4 (monthly) works as it should, but it is quite meaningless. All it does is transfer the value from cell I20 (weekly) if the month = February (D2, weekly) and the week number = 2 (H2, weekly)
Since your weekly schedule only keeps track of the current week, your formula for Week1 now returns -zero-, as either of these rules match (it wants to pick-up I20 for month February and week 1).
If you insist to keep the design of the schedule, you might as well transfer the weekly number to the monthly sheet, manually. Isn't that what you did for January? Though, capturing all your daily readings in one table (Date, Output, Reject, Machine, Comment) will allow you to make summaries and graphs from one single source.