In MS Excel I can add all positive values in a column with


But this isn't working in the Google Docs Spreadsheets. The ">0" part is not parsed and gives an error. Is there another method in Google Docs?


=sumif(A:A, ">0") works for me in Google Spreadsheet. There is a space between the comma and the first quotation mark.

You can also use =sumif(A:A; ">0") with a semicolon instead of a comma.

And without a space works =sumif(A:A,">0")

  • Just curious, you give the answer with and without a space between the , " -- is this just a aesthetic thing you do? – Nick Sep 18 '13 at 15:15
  • I like using spaces, it's easier for me to read longer formulas – Raystafarian Sep 18 '13 at 16:34
  • Thanks, I don't use google spreadsheets, I just wondered =) – Nick Sep 18 '13 at 18:01

It shows error when you include the cell. i.e. If you put formula in cell A1 and you want to take summation till A100, the formula should be =sumif(A2:A100; ">0")

  • That is because of a circular reference error. – Rubén Nov 20 '19 at 20:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.