Ask Your Question
0

err 509 in sumif

asked 2018-08-23 22:03:11 +0200

vankan@kabelfoon.nl 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
0

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

erAck gravatar image

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

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

Stats

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

Seen: 266 times

Last updated: Aug 24 '18