+ Reply to Thread
Results 1 to 2 of 2

Reporting back a cell value using SUMIF (multiple sheets)

  1. #1
    Registered User
    Join Date
    11-13-2006
    Posts
    4

    Reporting back a cell value using SUMIF (multiple sheets)

    Ok, I'm going to try this again. Say I have the following information in my spreadsheet:
    HTML Code: 
           (sheet 1)                 (sheet 2)              (sheet3)           etc...
    a1   Duration                    Duration               Duration
    a2      0:15                         0:02                    0:08
    a3      0:03                         0:01                    0:52
    a4      0:06                         0:05                    0:04
    ...
    a10   11/01/2006             11/02/2006          11/03/2006
    My spreadsheet tracks various information throughout the month (each day is on it's own sheet). The last sheet is a summary page with various totals and averages. There is also a calculation that figures the max duration for the month: ex. =MAX('11-01:11-30'!a2:a4). Now, I would like to also report the date that is located in a10 next to that max value. That way, the users of the sheet can easily be pointed to the date of the unusually long duration. This example is a simplified demonstration of the actual sheet, but should suffice. I tried using SUMIF, but that doesn't seem to work. I tried using the following: =SUMIF('11-01:11-30'!a2:a4,"=max('11-01:11-30'!a2:a4)",'11-01:11-30'!a10). Any suggestions?

    Thanks much,
    Kris
    Last edited by bumpcity76; 11-17-2006 at 06:19 PM. Reason: my spacing was goofy

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    3,993
    Hi,

    Something along these lines ...

    =Offset(CELL("Address",YourMax),0,1)

    YourMax being your max function ...

    HTH
    Carim

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1