Connect with experts and redefine what’s possible at work – join us at the Microsoft 365 Community Conference May 6-8. Learn more >
Trinh005Copper ContributorNov 28, 2023Enter the Sumif funcion but it displays like that, what should i do?
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)Trinh005Copper Contributor to HansVogelaarNov 30, 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)