Forum Discussion
Trinh005
Nov 28, 2023Copper Contributor
Enter the Sumif funcion but it displays like that, what should i do?
HansVogelaar
Nov 28, 2023MVP
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)
Trinh005
Nov 30, 2023Copper Contributor
thanks