summing grids/tables on the one page

[ajm]

I have inherited a file that requires data to be displayed in separate grids for each financial year. I haven't got to the bottom of "why" yet but am working on it. in the meantime, i need a more efficient way of summing the amounts received and the amounts paid out for years past. this is what it looks like:

There is a sum formula at the bottom of the page for summing the total amounts paid and then again for the total amounts received. these are getting longer each year. Rather than reformatting the layout so that the yearly grids are one on top of the other down the page, adding "Total" to the bottom line for each grid, and then doing sumifs for Received and Paid, is there a better way to do this?

 

[jasonb75]

Trying to extract anything useful from that is going to be painful. Personally, I would reformat the data in a way that suited what I needed to do with it, then create the tables from the reformatted data.

With what you have you might get away with entering the year in the empty cell next to the totals for each table then grabbing figures with sumproduct but that is not going to be efficient.

 

[ajm]

thanks Jasonb75. reformatting the data and deriving the grids and totals from that is a nice turnaround.