View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Myrna Larson[_3_] Myrna Larson[_3_] is offline
external usenet poster
 
Posts: 45
Default Bond prices: summarize ranges from different worksheets

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.


On Mon, 13 Oct 2003 16:01:59 -0400, bluebanker wrote:

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/attach...?postid=309051 (trial.xls)

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/