CODEWITHSUNDEEP
google-sheetsexcel-formulaformula
Shimmy Weitzhandler
Shimmy Weitzhandler

Reputation: 104721

Formula to select range by condition in Spreadsheets

I'm looking for a formula that summarizes a range of a column, filtered by a condition of another column in same row, e.g. the SUM of column B where value in column A is greater than x.

For example I want to have the sum of column F, where the date in column E of that row is within a week from now.

Upvotes: 0

Views: 2186

Answers (1)

Chris Hick
Chris Hick

Reputation: 3094

Does this formula work as you want:

=SUMIF(E:E,"<"&TODAY()+7,F:F)`

Upvotes: 1

Related Questions