Sum of alternate columns with subtotals

[HJimHB]

Hi

I have a report which pulls values from 2 sources (13 from each) for each month of the year, so 312 columns in total.

For each line, I need to subtotal each source per month to compare these totals, and also get the annual totals for comparison.

How can I get this?

Thanks in advance.

 

[HighAndWilder]

If the data was structured as below then the analysis would not need to consider what columns the values are in.

You would just need to add to this data table each month from each source.

Let me know if you would like me to post some code to restructure the new data each month?

This task could also be done manually.

 

[Fluff]

@HJimHB
Did you try the formula I suggested?

 

[HJimHB]

Hi guys - sorry, been busy so not had the chance to look into these yet - will give them a go when I can and will report back. Thank you again for your help.

 

[Fluff]

Ok, that's fair enough. Thanks for letting us know