Trinh005Copper ContributorNov 28, 2023Enter the Sumif funcion but it displays like that, what should i do?
2 RepliesReplies sorted by NewestHansVogelaarMVPNov 28, 2023Trinh005 Your screenshot shows that you use comma as decimal separator. Therefore, you should use semicolon ; to separate the arguments of a function, for example: =SUMIF(B2:B1000; ">37"; D2:D100)Trinh005Copper Contributor to HansVogelaarNov 29, 2023thanks
HansVogelaarMVPNov 28, 2023Trinh005 Your screenshot shows that you use comma as decimal separator. Therefore, you should use semicolon ; to separate the arguments of a function, for example: =SUMIF(B2:B1000; ">37"; D2:D100)