Max Value Based on Conditions

Thanks for the input Portuga.

I still don't believe a pivot table is the best solution for this data. Here's why;

1. I will have 35,712 rows of data for each month. I have over two years worth of summarized data right now. I will exceed the number of rows limit in Excel in two months. Then I'll have to add the data into different columns or different worksheets to continue using Pivot tables.
2. I don't need dynamic data. My data is static once it is calculated and summarized.
3. Each month I copy and paste the values and overlay the formulas in the cells, then delete the detail data. I'm just using the formulas to summarize the detail data the first time I add it in. The values will never change once calculated.
4. If I did create the pivot table, I would have to copy and paste the results into a more permanent spreadsheet, because again I would eventually have to start deleting the rows of detail data. I need to keep at least 13 months of summarized data for graphind purposes.

I would still like to find a way to get the MAX or LARGE functions to work with the four conditions. Can anyone help me out?