Hi - can someone advise why the following 'sumifs' doesn't work the same way as a normal 'sum', and suggest the correct the syntax to achieve this in the sumifs.

Capture.JPG