15

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

SUMIF(A:A,">0") 

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?

17

=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? – 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 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.