Sumif not responding

[WILSONYOM]

Spoiler

I am trying to use the sumif formula and it is not responding.Here, i input the formularBut i keep getting this

[#2]

@WILSONYOM 

Do you happen to use semicolon as list separator? If so, try

=SUMIF(F2:F172;">50")

[#3]

@Hans Vogelaar still doesn't work. maybe i need to get the latest excel, i use the 2013 software

[#4]

@WILSONYOM 

No, SUMIF should work in all versions of Excel.

If you attach a copy of your workbook (without sensitive information) to a reply, I or another user can add the SUMIF formula and post the workbook with the formula. You could then check whether it works on your computer.

[#5 · Accepted solution]

@WILSONYOM 

You may open attached workbook to check how formula looks like in your locale. There is nothing in workbook but

[#6]

Fixed, Thanks.

[#7]

@WILSONYOM , you are welcome