What Im looking to do is, if O column has an "x", count how a range of numbers. AW column has numbers that fall in the 20's, 30's, 40's etc. I want to do something like less than 40 greater than 30. I tried AND but that caused an error.
=SUMPRODUCT(O2:O168="x", $AW$2:$AW$168 <30) -- 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