The Sumif formulae mentioned is not working on my excel.

The popup shows that the input is incorrect and hence we cannot move ahead, Is there any other way out? Thanks!