Hi ,

I have a spreadsheet that has multiple values for each of the dates in the year 2009. I also have another column that has a type associated with the date .

this is what i would like to find using a formula

1. for each date and for each type sum values
2. find the maximum of the values for each type

Is this possible through the use of max and sum /if using an array formula


thanks

tony