Recent DiscussionsMost RecentNewest TopicsMost LikesSolutionsTagged:TagRe: Trying to use COUNT.IFS in Finnish ExcelThank you!!! This was the mistake I didnt know I made! Now the formula works! 🙂Re: Trying to use COUNT.IFS in Finnish ExcelWill try this! Thanks!Re: Trying to use COUNT.IFS in Finnish Excel Detlef_Lewin Thank you again. Yes, it says that they are all TRUE (in finnish TOSI). Re: Trying to use COUNT.IFS in Finnish ExcelThank 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.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? Solved
