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

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. – w3dk 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
up vote 15 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. – w3dk May 3 '13 at 16:13
Thanks! Another useful one is: =sum(Filter(A2:A, B2:B > EOMonth(now(), -1))), which sums all of the values for the current month, where A2:A contains the values, and B2:B contains the associated date. – jpaugh Jul 22 '15 at 1:53

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.