brianfosterblack
Active Member
- Joined
- Nov 1, 2011
- Messages
- 251
so I want to know if I can do this as a formula or do I need to run a macro
I want to add up the time spent on each client in each month
On my "Clients" Sheet I have all my client listed in Column C from row 4 downwards
In row 3 from columns "I" to "T" I have the 12 months starting from Mar and ending with Feb (This abbreviated version of the months corresponds to the sheet name for each month)
Lets just take the "Mar" sheet
The client name which corresponds to the client name in my Client Sheet is in Column A from A6 Downwards
The days of the month are in column "E" to "AI" in row 5
Each row in the month only has 1 client in that row and 1 time under 1 of the days in the month
I need on my Client Sheet to add up all the time spent on that client in Mar month and then for each other month in the column for that month.
Can this be done as a formula or will I need to run a macro
I
I want to add up the time spent on each client in each month
On my "Clients" Sheet I have all my client listed in Column C from row 4 downwards
In row 3 from columns "I" to "T" I have the 12 months starting from Mar and ending with Feb (This abbreviated version of the months corresponds to the sheet name for each month)
Lets just take the "Mar" sheet
The client name which corresponds to the client name in my Client Sheet is in Column A from A6 Downwards
The days of the month are in column "E" to "AI" in row 5
Each row in the month only has 1 client in that row and 1 time under 1 of the days in the month
I need on my Client Sheet to add up all the time spent on that client in Mar month and then for each other month in the column for that month.
Can this be done as a formula or will I need to run a macro
I