Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenTue, 08 Dec 2015 17:47:10 +0100What's wrong with this formula?https://ask.libreoffice.org/en/question/61729/whats-wrong-with-this-formula/Hi,
I have a standard filter applied to one or more columns and need to count the resulting **visible** cells in another column that equal a certain value. In Excel this can be done with the following formula:-
=SUMPRODUCT(SUBTOTAL(3,OFFSET(BH10,ROW(BH10:BH1000)-ROW(BH10),0))*(BH10:BH1000="T"))
This counts the number of visible cells in column BH that equal "T". The result happens to be 29, however when I use this same formula in Calc on the same spreadsheet I get 270538 !. Anyone know what could be going on here?. Thanks. p.s. I should add that it makes no difference if the formula is entered as an array formula or not.
LO 4.4.6.3 on Linux.redartTue, 08 Dec 2015 17:47:10 +0100https://ask.libreoffice.org/en/question/61729/