I have daily data all on different worksheets (31 in total) and I would like to add up all of the data in these worksheets in a monthly compilation
I have so far been using the =sum('jan. 1'!B6, 'jan. 2'!B6 ... etc.) which although is effective is very time consuming
is there an easier way to sum up all of the b6 cells without entering them individually?
Thanks
Bookmarks