{"action":"created","issue":{"url":"https://api.github.com/repos/wolfascu/GoogleApps_SumByColor/issues/3","labels_url":"https://api.github.com/repos/wolfascu/GoogleApps_SumByColor/issues/3/labels{/name}","comments_url":"https://api.github.com/repos/wolfascu/GoogleApps_SumByColor/issues/3/comments","events_url":"https://api.github.com/repos/wolfascu/GoogleApps_SumByColor/issues/3/events","html_url":"https://github.com/wolfascu/GoogleApps_SumByColor/issues/3","id":109418235,"number":3,"title":"Code is not pulling correct numbers on entry","user":{"login":"delize","id":4028612,"avatar_url":"https://avatars.githubusercontent.com/u/4028612?v=3","gravatar_id":"","url":"https://api.github.com/users/delize","html_url":"https://github.com/delize","followers_url":"https://api.github.com/users/delize/followers","following_url":"https://api.github.com/users/delize/following{/other_user}","gists_url":"https://api.github.com/users/delize/gists{/gist_id}","starred_url":"https://api.github.com/users/delize/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/delize/subscriptions","organizations_url":"https://api.github.com/users/delize/orgs","repos_url":"https://api.github.com/users/delize/repos","events_url":"https://api.github.com/users/delize/events{/privacy}","received_events_url":"https://api.github.com/users/delize/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-10-02T02:09:39Z","updated_at":"2015-10-02T10:15:13Z","closed_at":null,"body":"After coming across your code on stackoverflow, it looks like this is exactly what I need. I was pretty excited to try it out as it would help me simplify my spreadsheet\r\n\r\nSo I set it up, used the \"getBackgroundColor\" function with \"\" around the cell number, and it pulls the color code (in this case #ff0000 or #b7b7b7). However, when I use the \"sumWhereBackgroundColorIs(\"#ff0000\",\"B3:B500\", \"\", \"B3:B500\")\" it responds with 0 cells holding that color, even though I have in B3 that is being used by getBackgroundColor to let me know at hex code to check for.\r\n\r\nI really do think this would do exactly what I am hoping for. I tried using the Google Scripts debugger, but it isn't incredibly helpful in this situation (as it expects there to be a range of something, and there isn't one)."},"comment":{"url":"https://api.github.com/repos/wolfascu/GoogleApps_SumByColor/issues/comments/144983122","html_url":"https://github.com/wolfascu/GoogleApps_SumByColor/issues/3#issuecomment-144983122","issue_url":"https://api.github.com/repos/wolfascu/GoogleApps_SumByColor/issues/3","id":144983122,"user":{"login":"delize","id":4028612,"avatar_url":"https://avatars.githubusercontent.com/u/4028612?v=3","gravatar_id":"","url":"https://api.github.com/users/delize","html_url":"https://github.com/delize","followers_url":"https://api.github.com/users/delize/followers","following_url":"https://api.github.com/users/delize/following{/other_user}","gists_url":"https://api.github.com/users/delize/gists{/gist_id}","starred_url":"https://api.github.com/users/delize/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/delize/subscriptions","organizations_url":"https://api.github.com/users/delize/orgs","repos_url":"https://api.github.com/users/delize/repos","events_url":"https://api.github.com/users/delize/events{/privacy}","received_events_url":"https://api.github.com/users/delize/received_events","type":"User","site_admin":false},"created_at":"2015-10-02T10:15:13Z","updated_at":"2015-10-02T10:15:13Z","body":"Unless I am mistaken, shouldn't the count be two? As the background color in cells B4 and C4 do not meet #ff0000 requirement? \r\n\r\n"}}