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...
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))
Try a pivot table.
Date in rows area. Grouping by year and month.
And Date in values area. Aggregated by Count.
Will try this! Thanks!
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!!! This was the mistake I didnt know I made!
Now the formula works! 🙂