Sum every 'X' number of Rows- Multiple Columns

Hello.

I have a data pull (below image) where I would like to sum every 7 rows across all column (the number of columns will not remain constant).

I am pretty positive this can be obtained using the Multi-Row tool, however I am not figuring out the Expression for the sum and I am not sure how to handle the dynamic number of columns aspect.

Help

Preparation

Data Investigation

Accepted answers

Yoshiro_Fujimori

@ScubaGeekNV ,

Here is a sample workflow. (It's the same as @OTrieger 's 1st idea.)

I hope this helps.

Workflow

Output

RowNo	a	b	c	d	e	Group
1	47	84	98	73	76	1
2	75	57	17	10	60	1
3	22	27	57	92	60	1
4	88	41	57	76	34	1
5	79	23	78	56	64	1
6	27	81	2	2	58	1
7	2	75	96	53	38	1
Total	340	388	405	362	390	1
8	75	89	71	57	40	2
9	10	98	27	99	47	2
10	78	54	92	23	99	2
11	78	35	98	18	36	2
12	21	44	4	33	78	2
13	71	41	14	51	24	2
14	23	65	69	22	23	2
Total	356	426	375	303	347	2

SumEveryX.yxmd

All comments

OTrieger

@ScubaGeekNV
I think that using Multi Row Formula tool would be too complex to get it done, nevertheless you can try to go with that solution.

I think that it will be easier the create flags that indicating 7 rows, Flag 1 from 1 to 7, flag 2 from 8 to 14 etc. Then use Cross Tab tool or Summarize tool to get the values sum up.

Or you can use batch macro to get it done.

Yoshiro_Fujimori

@ScubaGeekNV ,

Here is a sample workflow. (It's the same as @OTrieger 's 1st idea.)

I hope this helps.

Workflow

Output

RowNo	a	b	c	d	e	Group
1	47	84	98	73	76	1
2	75	57	17	10	60	1
3	22	27	57	92	60	1
4	88	41	57	76	34	1
5	79	23	78	56	64	1
6	27	81	2	2	58	1
7	2	75	96	53	38	1
Total	340	388	405	362	390	1
8	75	89	71	57	40	2
9	10	98	27	99	47	2
10	78	54	92	23	99	2
11	78	35	98	18	36	2
12	21	44	4	33	78	2
13	71	41	14	51	24	2
14	23	65	69	22	23	2
Total	356	426	375	303	347	2

SumEveryX.yxmd

flying008

Hi, @ScubaGeekNV

Another way like @Yoshiro_Fujimori .

录制_2024_11_01_08_23_16_657.gif

ScubaGeekNV

Glad to here the Multi-Row tool would be too complicated, now I do not feel bad for not figuring that option out! LOL

This solution works perfectly! Thank you for your help.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703