CODEWITHSUNDEEP
filtergoogle-sheets
user3440143
user3440143

Reputation: 11

Google Sheets - Sum values based on date range

I have a column of dates, column C, and a column of values, column G. I want to be able to calculate monthly totals of column G. I've poked around and found that you can use sumif or you can use a filter. The filter method seems easier. I've tried the following but it doesn't work.

=sum(filter(C3:C365,G3:G365>date(3/1/2016),G3:G365<date(3/31/2016)))

How can I check the dates in column C and then sum up the values from column G?

Thanks Rich

Upvotes: 0

Views: 2148

Answers (1)

Ed Nelson
Ed Nelson

Reputation: 10259

Try:

=sumproduct(MONTH(C2:C) = 3,B2:B)

Three is the month number (March).

Upvotes: 1

Related Questions