Ok, I have a monthly spreadsheet with daily information on individual sheets. I have included a summary page that gives totals, averages, and MIN/MAX values for amounts, volumes, and times. Each sheet has the same information for three entities. Therefore, values are by individual entity and combined. Example Maximum function for the combined entities would be: =MAX('11-01:11-30'!E8:E10,'11-01:11-30'!E16:E29,'11-01:11-30'!E35:E48). The problem I am having is that I want to report the date that corresponds to the sheet that contains the maximum/minimum values (the date is contained in M4 of each sheet). I've tried using SUMIF (=SUMIF('11-01:11-30'!E8:E10,'11-01:11-30'!E16:E29,'11-01:11-30'!E35:E48,"=MAX('11-01:11-30'!E8:E10,'11-01:11-30'!E16:E29,'11-01:11-30'!E35:E48),'11-01:11-30'!M4)), but that only works on a single sheet. I'm trying to avoid a ton of nested IF's. Any suggestions?
Thanks,
Kris
Bookmarks