The IF statement will expect a condition to test, not and another AND. With Warm Regards
V.Kadal Amutham 919444360480 914422396480 On 1 June 2013 01:40, Johnny Rosenberg <gurus.knu...@gmail.com> wrote: > Column C: Name > Column D: Date > Column H: Points > > I want to see the highest point for the name in P3 for dates in this > year (2013). > > I can do highest score for the name that's stored in P3, regardless of the > year: > {=MAX(IF(C2:C10000=P3; H2:H10000; 0))} > Result: 612. > Expected result: 612. > > And the highest score for the this year, regardless of name: > {=MAX(IF(YEAR(D2:D10000)=YEAR(TODAY()); H2:H10000; 0))} > Result: 596. > Expected result: 596. > > I tried the following: > {=MAX(IF(AND(YEAR(D2:D10000)=YEAR(TODAY());C2:C10000=P3); H2:H10000; 0))} > Result: 0. > Expected result: 588. > > I obviously misunderstood the whole concept, so how is it supposed to be > done? > > > Johnny Rosenberg > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted