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


--
mark_vi_
------------------------------------------------------------------------
mark_vi_'s Profile: http://www.excelforum.com/member.php...o&userid=24507
View this thread: http://www.excelforum.com/showthread...hreadid=381020