Forum Discussion

Trinh005's avatar
Trinh005
Copper Contributor
Nov 28, 2023

Enter the Sumif funcion but it displays like that, what should i do?

  • Trinh005 

    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)

Resources