Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 6 down vote accepted

=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")

share|improve this answer
Just curious, you give the answer with and without a space between the , " -- is this just a aesthetic thing you do? – Nicholas V. 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 =) – Nicholas V. Sep 18 '13 at 18:01

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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