# Summing a column, filtered based on another column in 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):

``````=SUM(A1:A5)
``````

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

``````=SUM(FILTER(A1:A5;B1:B5="Yes")
``````
-
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

``````=SUM(FILTER(A1:A5,B1:B5="Yes")
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