Forum Discussion

Copper Contributor

Jun 21, 2023

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...

excel

Formulas and Functions

Riny_van_Eekelen
Jun 21, 2023
SannaHalinen
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))

Detlef_Lewin

Silver Contributor

Jun 21, 2023

SannaHalinen

Your ranges are not the same size.

SannaHalinen

Copper Contributor

Jun 21, 2023

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.

Detlef_Lewin
Silver Contributor
Jun 21, 2023
SannaHalinen
Check N4..N1000 with ISNUMBER(). Are they all TRUE?
- SannaHalinen
  Copper Contributor
  Jun 21, 2023
  Detlef_Lewin
  
  Thank you again. Yes, it says that they are all TRUE (in finnish TOSI).
  - Detlef_Lewin
    Silver Contributor
    Jun 21, 2023
    SannaHalinen
    Try a pivot table.
    Date in rows area. Grouping by year and month.
    And Date in values area. Aggregated by Count.