Sum values in a column with condition

[Ravi]

Hello! I am looking for some help on summing value on column "Hours" if my values in column "Date" "Region" "ID" and "Person" matches. The below highlighted set of 3 rows I am looking to fix. My first criteria is for the date to match as the data reflects an erroneous entry made, then corrected with a negative entry and a correct entry for the same date with right comments. Any help is appreciated! 

Region	ID	Person	Date	Comments	Hours
APAC	23456	A	12/9/2022	In-Progress	8
APAC	23456	C	12/3/2022	On Hold	9
EMEA	30981	A	12/2/2022	Not Started	3
LAD	85109	C	12/1/2022	Roadblock	4
LAD	85109	C	12/1/2022	Not Started	4
LAD	85109	C	12/1/2022	Not Started	-4
NA	34619	E	12/9/2022	In-Progress	4
NA	34619	A	12/9/2022	Completed	10
NA	34619	A	12/2/2022	Completed	12
APAC	23456	C	12/5/2022	Not Started	4
NA	34619	D	12/9/2022	In-Progress	3
EMEA	30981	E	12/7/2022	On Hold	-10
EMEA	30981	E	12/7/2022	On Hold	10
EMEA	30981	E	12/7/2022	Roadblock	10
LAD	85109	B	12/9/2022	Completed	23
NA	34619	A	12/9/2022	On Hold	2
NA	34619	A	12/9/2022	On Hold	-2
NA	34619	A	12/9/2022	Completed	2
APAC	23456	C	12/9/2022	Not Started	10
LAD	85109	B	12/1/2022	Not Started	4
EMEA	30981	D	12/7/2022	On Hold	10

Output I am looking for 

Region	ID	Person	Date	Comments	Hours
APAC	23456	A	12/9/2022	In-Progress	8
APAC	23456	C	12/3/2022	On Hold	9
EMEA	30981	A	12/2/2022	Not Started	3
LAD	85109	C	12/1/2022	Roadblock	4
NA	34619	E	12/9/2022	In-Progress	4
NA	34619	A	12/9/2022	Completed	10
NA	34619	A	12/2/2022	Completed	12
APAC	23456	C	12/5/2022	Not Started	4
NA	34619	D	12/9/2022	In-Progress	3
EMEA	30981	E	12/7/2022	Roadblock	10
LAD	85109	B	12/9/2022	Completed	23
NA	34619	A	12/9/2022	Completed	2
APAC	23456	C	12/9/2022	Not Started	10
LAD	85109	B	12/1/2022	Not Started	4
EMEA	30981	D	12/7/2022	On Hold	10

[PanPP]

Hi @Ravi 

I have uploaded a sample WF to summarize the hours by Date/Region/ID. I am not too sure what your desired output is.

Hope this helps.

[DenisZ]

Could you just not use the Sum formula for this, or am I missing something?.

[Raj]

just use the summarize tool with the fields "Date" "Region" "ID" and "Person" grouping by and sum "hours" .

then by removing "0" from hours you will get the output.

[Ravi]

@DenisZ  After sum I want to keep the row which is unique of the three in column "Comments".

[Raj]

[Ravi]

Thanks @Raj I liked what you did but I also have zeroes in my actual data. I leveraged your suggestion and made a tweak to filter all rows with value zeroes, then summarize all columns including "Comments". Finally removed zeroes and then bring back my filtered data which had zeroes.

[DavidSkaife]

Hi @Ravi 

The summerise and Filter approach works to an extent, but the below fields end up grouping and summing as well:

The attached should deal with this issue