Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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?

share|improve this question
add comment

1 Answer

up vote 2 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
add comment

Your Answer

 
discard

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.