CODEWITHSUNDEEP
google-sheets
Diego Silvera
Diego Silvera

Reputation: 201

Sum over certains rows in google spreadsheets

I have a table like this and I want that if the column "Dia" there is a change in the month, then in the column "Suma mes" appears the sum over the numbers in column "Horas" that share the same month. As you can see, in cell E14 appears the sum of "Horas" in month August.

I can get the month from the column "Dia", but I dont know how to use this as a criterion in SUMIF. This is part of ifttt applet to track my work hours.

Thank you.

Upvotes: 0

Views: 40

Answers (1)

Ed Nelson
Ed Nelson

Reputation: 10259

First, you need to create a custom date format and format column A like this:

dddd", "d" "mmmm","yy

Then to sum August use (column D last August entry) :

=arrayformula(sumif(month(A:A),"=8",D:D))

Here is a share if my test spreadsheet:

https://docs.google.com/spreadsheets/d/1ZWg9pXVPpBqh1-BykTEnoreZGoAKn-YZmNq3bfYz30k/edit?usp=sharing

Upvotes: 1

Related Questions