Query fails with SELECT A, SUM(B) + SUM(C) GROUP BY A

Given a Google Sheet with the following data:

If I enter this function:

=query(A1:C3, "select A, sum(B) + sum(C) group by A", 0)

I get the following in A5:

What I expected was:

Note that both C1 and B3 are empty cells.If I set C1 to 0, it works as expected. Setting B3 to 0 has no effect. I would rather not clutter up my spreadsheet with a bunch of zeros. Any ideas?

Try the following:

=query(arrayformula({A1:A3, n(B1:C3)}), "select Col1, sum(Col2)+sum(Col3) group by Col1 label Col1'Name', sum(Col2)+sum(Col3)'Sum'")

How it works:

• The formula recreates the table filled with your data, replacing any blank cells with 0, so you won't need to put in zeroes in your spreadsheet directly. Afterwards, it is used with the query function to essentially sum the total of your values.

Output