Forum Discussion
Solved
Trying to use COUNT.IFS in Finnish Excel
Hi,
I´m trying to use this formula:
=LASKE.JOS.JOUKKO(D4:D500; "KV"; N4:N1000; ">= " & PÄIVÄMÄÄRÄ(2023;1;1); N4:N1000; "<= " & PÄIVÄMÄÄRÄ(2023;1;31))
But it does not work and I cannot figure out why?
Created a formula in English believing it does what you need. When I then pull it through an Excel translator I get this in Finnish:
=LASKE.JOS.JOUKKO(D4:D1000;"KV";N4:N1000;">= "&PÄIVÄYS(2023;1;1);N4:N1000;"<= "&PÄIVÄYS(2023;1;31))
- Thank you for the tip! I changed the range and it still gives only 0 as the answer but there should be more.
I have checked the date format and text format and everything should be correct.
