Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSat, 17 Oct 2020 04:11:58 +0200using isodd with countifhttps://ask.libreoffice.org/en/question/271770/using-isodd-with-countif/ Hi, noob question, how do I use ISODD with COUNTIF? I want to provide a count of the number of odd (or even) numbers that occur in a range of numbers but I don't know how to use the ISODD function within the range used in COUNTIF e.g. something like =COUNTIF(A1:F1,ISODD(?)) what goes into (?) A1:F1 might contain 1,1,2,2,3,3 so the result should be 4 in this case. I realise I could set up an ISODD test for each cell then sum the results but was hoping for a more concise way of expressing as one formula?
Cheers
Greg rootopiaSat, 17 Oct 2020 04:11:58 +0200https://ask.libreoffice.org/en/question/271770/