CODEWITHSUNDEEP
google-sheetsspreadsheet
rumburak
rumburak

Reputation: 1137

Sum values from month

I have a table of values, dates and categories:

5   1.09.2013   red
-7  2.09.2013   red
9   21.09.2013  red
-2  3.10.2013   red
11  28.09.2013  green
3   2.10.2013   green
8   16.10.2013  green

I calculate sum of values where category is green with:

=sum(filter(A:A;C:C="green"))

How to sum just values from October where category is green ?

Upvotes: 0

Views: 148

Answers (1)

wchiquito
wchiquito

Reputation: 16551

The following formula can help:

=SUM(FILTER(A:A, C:C = "green", VALUE(REGEXREPLACE(B:B, "^\d+\.|\.\d+$", "")) >= 10))

UPDATE

Here a sample with the test data set.

enter image description here

Upvotes: 1

Related Questions