This blog is a collection of the Excel files I created. I made screen shots of all the files.
I tried to improve Excel skill and received the certificate of Microsoft Office Specialist Certification- Excel 2003 Expert in 2010.
Sunday, March 1, 2009
Consolidating data from multiple worksheets using a 3-D reference
= Worksheet Range!Cell Range
= SUM(Sheet1:Sheet4!B21)
This formula adds the values in cell B21 on the worksheets between Sheet 1 and Sheet 4
No comments:
Post a Comment