mystique07
New Member
- Joined
- Mar 30, 2018
- Messages
- 12
We have multiple projects and I need to report the weekly consumed hours each week.
i have used SUMIFS to get the monthly totals. but don't know how to get the consumed hours as of each week which should be total hours - consumed till date.
i have used SUMIFS to get the monthly totals. but don't know how to get the consumed hours as of each week which should be total hours - consumed till date.
Book1 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | Name | Project | Jun | Jul | Aug | 4-Sep | 11-Sep | 18-Sep | 25-Sep | ||
2 | Name 1 | ABC | 100 | 50 | 100 | 40 | 40 | 40 | 40 | ||
3 | Name 2 | ABC | 100 | 50 | 100 | 20 | 20 | 20 | 20 | ||
4 | Name 2 | MNC | 100 | 50 | 100 | 20 | 20 | 20 | 20 | ||
Sheet1 |