I have a spread sheet I use to manage a soccer league. This shows me of the registered players who is on Dk Blue team. =SUMPRODUCT($AU$2:$AU$131="Dk Blue", $O$2:$O$131="x")
This shows me the team strength based on assigned values of the players. =SUMPRODUCT($AU$2:$AU$131="Dk Blue", $AW$2:$AW$131) I would like to do something like this (this will not work): =SUMIF($O$2:$O$131="x",$AU$2:$AU$131="Dk Blue", $AW$2:$AW$131) If 02-0131 is the Spring registration column. If there is a "x" there then I know they are playing for the year. I would like to say, "If they are registered for spring then add up the points in AW2-131 if they are on TeamName. Any ideas appreciated. Wade -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 -- 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