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
Bookmarks