Libre Office 25.8.3.2 running on Windows 10 PC
I am building a spread sheet that requires a search function of a range of cells using variable dates to return the count of numerical data entries that are <0.
This is the formula I am using =COUNTIFS(A11:A101, “>=M4”, A11:A101, “<=M5”, P11:P101, “<0”)
From the test range it should return 2 but is returning 0, I also need the same formula for >0 search this should return 9 but returns 0.
All the date cells are formatted correctly as the search range of cells ie date formats and numerals and no text, the search range is the result of a sum of other columns but to check I created a column of pure numbers no formulas and received the same result ie 0 return.
Can anyone throw any light on this, the problem is stopping completing the spread sheet.
As I typed this I wondered if the >0 <0 are the problem and maybe if I changed to <0.1 & >0.1, Ill try this meanwhile but I think it unlikely.