I am using Libre 7.5.22.
I am trying to count(countif and countifs) some data based on date >= than date.
I have a colum of data in a sheet(a named range) and counting in another sheet based on a cell as reference in the same calcullation sheet
The formula I applied is Countif(named range, >=cell reference). I have also tried Coutif(…,">=cell reference"), (…,">=Value(cell), (…,">text(cell)" I checked all counting data has data format and without any success. The only way I managed to make it work is be using(…, ">=date as text), but is not what I am after.
Am I doing something wrong or what I am trying to achieve is not possible?