Code is not pulling correct numbers on entry about googleapps_sumbycolor HOT 7 CLOSED

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

from googleapps_sumbycolor.

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

from googleapps_sumbycolor.

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

from googleapps_sumbycolor.

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

from googleapps_sumbycolor.

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.

from googleapps_sumbycolor.

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

from googleapps_sumbycolor.

Awesome! Glad this is solved.

from googleapps_sumbycolor.