Summarizing a report

Hi fa2020,

Is your expected results EM=26 & PM=18 ? I'm sure you know that this can easily be achieved with SumIf but looks to me you want to learn more about VBA dictionary ... Try the below

Edit: I just re-read your question & seems you need more details than EM=26 & PM=18 which I found in your file. If this is not your final target, please post what's your expected results look like based on the sample file in post #1

Please Login or Register  to view this content.

An alternative is to use Power Query/Get and Transform located on the Data Tab. Here is the Mcode from the action.

Please Login or Register  to view this content.

Excel 2016 (Windows) 32 bit

	A	B	C	D	E
1	Date	Maintenance Type	Department	Personnel Name	Total Time
2	5/12/2020	EM	Mechanical	Jennifer	3
3	5/12/2020	EM	Electrical	Alex	8
4	5/13/2020	PM	Electrical	Alex	2
5	5/13/2020	PM	Mechanical	Jennifer	4
6	5/13/2020	EM	Electrical	Amanda	3
7	5/13/2020	EM	Mechanical	Alex	7
8	5/14/2020	EM	Industrial Engineering	Amanda	5
9	5/14/2020	PM	Electrical	David	4
10	5/15/2020	PM	Industrial Engineering	Amanda	8

Sheet: Sheet1

Review PQ
In the attached file
Click on any cell in the new table
On the Data Tab, click on Queries & Connections
In the right window, double click to open Query
Review PQ steps

M-code basics:
- "let" is the start of a query
- "in" is the closing of a query
- each transformation step sits in between those 2 lines
- each step line is ended by a comma, except the last one
- "Source" is always the first step (Source Data)
- After "in" you have the last step referenced

Originally Posted by nankw83

Hi fa2020,
Edit: I just re-read your question & seems you need more details than EM=26 & PM=18 which I found in your file. If this is not your final target, please post what's your expected results look like based on the sample file in post #1
[/code]

Thank you for response. Yes, I need more details about the personnel activity. I provided an example in the right side. I need the same result using VBA.
I want to have total work time based on each date. Also, personnel name and their department should be in the final result. My sample desired result at the right of my sheet can tell everything.
And if it is possible, Please share the SumIfs syntax method in VBA for achieving my desired result too.

Is this how you wanted?

Please Login or Register  to view this content.

This would be easier to understand.

Please Login or Register  to view this content.