Here's my test sheet:
Localization is USA with timezone GMT+1 I've tried substituting ',' with ';' to no avail.
As you can see, sumif/sumifs with open ranges returns #ERROR.
I know it should work because I've done
sumifs with open ranges before and worked as intended.
Can someone help?