Bond prices: summarize ranges from different worksheets

  • Thread starter Thread starter bluebanker
  • Start date Start date
B

bluebanker

I have a workbook where we track daily price ranges of certain
securities. Every day a new sheet is created. I put all of the
worksheets from one year into one workbook and now I am not sure how to
summarize all the data into one worksheet per month. In other words, I
need to summarize teh price ranges of the securities in April or
July.... .
I attached a similar spreadsheet. Please help me out on this one.

File Attached: http://www.exceltip.com/forum/attachment.php?postid=309051 (trial.xls)
 
Check out 3-D ranges in Help. Let's say you name the sheets in this format: Jan01, Jan02...
Jan31, etc.

=MIN(Jan01:Jan31!A1)

Will give you the minimum value in cell A1 of the 31 sheets for January. Note that the sheets
should be in order, with Jan01 the 1st sheet and Jan31 the 31st, Feb01 the 32nd, etc. The two
sheets you specify in the formula are the 1st and last sheet, looking at the sheet tabs at the
bottom of the window.
 
Back
Top