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:-
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 184.108.40.206 on Linux.