+ Reply to Thread
Results 1 to 2 of 2

Reporting back a cell value using SUMIF (multiple sheets)

  1. #1
    Registered User
    Join Date

    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,
    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

    Something along these lines ...


    YourMax being your max function ...


+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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