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?
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?