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.

I have the following data in a Google Spreadsheet:

| Time | Include |
| 0:30 | No      |
| 1:00 | Yes     |
| 0:30 | Yes     |
| 0:30 | No      |
| 0:30 | Yes     |

I would like to add up the time where the column to the right is "Yes".

I am using the following to add up all time (3:00):


and I've tried the following to add up the time (2:00) where the adjacent column is Yes, but Google reports "#ERROR!":

share|improve this question
If you'd searched here on Web Applications, then you would've found a few examples on how to do a summation. Another way of doing it is by using the SUMIF formula: =SUMIF(B2:B6;"Yes";A2:A6) –  Jacob Jan Tuinstra May 3 '13 at 11:30
The reason to why you need a comma in stead of a semicolon, has to do with the time-zone your in. Europe uses a comma as where USA uses a semicolon. –  Jacob Jan Tuinstra May 3 '13 at 11:37
@JacobJanTuinstra: Whether you can use a comma or semicolon is not necessarily related to the timezone, but with the locale/_language_ settings. Specifically whether the comma is being used as a decimal separator. If it is then you can't use a comma to also separate function arguments. In English we generally use a period as a decimal separator, so we can use either. –  w3d May 3 '13 at 16:11
Why don't you accept your own answer, so that future visitors can benefit from it. –  Jacob Jan Tuinstra Jul 28 '14 at 9:18

1 Answer 1

up vote 5 down vote accepted

Just realised FILTER should be comma separated:

share|improve this answer
Note that whether you need to use a comma or semicolon to separate function arguments is dependent on your language settings. –  w3d May 3 '13 at 16:13

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.