Code is not pulling correct numbers on entry

[delize]

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

So 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.

I 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).

[clupasq]

@delize Try removing the quotes around the last parameter:

=sumWhereBackgroundColorIs("#ff0000","B3:B500", "", B3:B500)

If it still doesn't work, perhaps you can share the document so I can take a look.

[delize]

I get the following results (same issue, except now it displays #NUM) with the above string.

I unfortunately can't share this specific spreadsheet, but I can try to share a different spreadsheet where I get the same result. I have displayed pictures of the initial spreadsheet below. I know in the last picture it says #00ff00, as I was testing a green background instead of red for that "getbackgroundcolor"

Here is a spreadsheet where I receive the same issue.
https://docs.google.com/spreadsheets/d/1suirxEiZH9o7bkN1Pd9sVM5v0P-00vapVv6RrIoeUhQ/edit?usp=sharing

[clupasq]

For me, the doc you shared seems to work fine:

[delize]

Unless I am mistaken, shouldn't the count be two? As the background color in cells B4 and C4 do not meet #ff0000 requirement?

[clupasq]

It's not a count; it's a sum. And if the sum encounters cells with non-numeric values it assumes them to be 0.

[delize]

Yeah, I just realized that after re-reading the description again. Im mistaken. Thanks for your instant response time though. My bad.

[clupasq]

Awesome! Glad this is solved.