Writing a Google Sheet for personal expenses I am trying to create a query to sum the expenses of a type, but the editor is retrieving a parse error that I can't achieve the logs (not sure it is possible).

Please consider only rows below row 15.

On Cell B9 I'd like to sum every expense of type Saúde. Can you help me understand what I am doing wrong?

D column represents the amount of the expense.

C column represents the type of the expense.

Query: =QUERY(C16:C1000,"select sum(D) where C = 'Saúde'")

(Plus) Curiosity apart: is possible to set up the sheet to write some rows and then the sheet push below rows to beneath then I could write the data ever on the top instead at the last row bottom?

CodePudding user response：

use:

=QUERY(C16:D1000; "select sum(D) where C = 'Saúde'"; )

see (not):