Double Row Footer Summing Alternate Table Rows

drewy

Hi All

I have a table that shows the quantity of operatives and count of activities for different companies.

The rows of the table alternate for each company with the sum of the ops on the first row and count of activities on the second. I am looking for a solution where the footer of the table has two rows and sums the odd numbered ops rows on the top footer row and the even numbered activity table rows on the bottom.

for example first footer row sums main table rows 1, 3, 5, 7, etc and second footer row sums main table rows 2, 4, 6, 8, etc

Thanks in advance