Ask Your Question

err 509 in sumif

asked 2018-08-23 22:03:11 +0100 gravatar image

updated 2020-08-23 17:22:57 +0100

Alex Kemp gravatar image

I get Err 509 with the statement sumif(i2:i234;B2;G2:G234) The column i contains numbers corresponding to the index in B2. Some are equal, some are not. The idea is that the sum extends over tose indices in column i that are equal to B2. What am I doing wrong? Thanks, Jos

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-08-24 14:03:38 +0100

erAck gravatar image

updated 2018-08-24 14:04:14 +0100

Err:509 means operator expected, make sure you don't have a typo in your formula expression. If in doubt copy&paste it to here exactly as it is without altering. If indeed you entered =sumif(... and it remains lower case (if recognized it would be shown upper case) then you're probably using an UI language that has localized function names (i.e. Dutch), so that could be SOM.ALS instead.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-08-23 22:03:11 +0100

Seen: 2,947 times

Last updated: Aug 24 '18