Why not: =SUMPRODUCT($O$2:$O$131="x",$AU$2:$AU$131="Dk Blue", $AW$2:$AW$131) the function multiply the values for every argument, if a condition is true their result is 1, what implies if both are true= 1 * 1 * AWvalue and this result is added.
and depends on your version you can do it: =SUMIFS( $AW$2:$AW$131,$O$2:$O$131,"x",$AU$2:$AU$131,"Dk Blue") Miguel Ángel. -- View this message in context: http://nabble.documentfoundation.org/SumIF-SumProduct-question-tp4117138p4117145.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: [email protected] 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
