CODEWITHSUNDEEP
google-sheetssumgoogle-sheets-formulasumifs
KhanZeeshan
KhanZeeshan

Reputation: 1410

Google Spreadsheet - SUMIF Date Range

I'm trying to create a spreadsheet, in which I want to sum the table if records are older than 1 year.

I have inventory in 1 sheet with purchase date and other stuff, and in 2nd sheet, I want to sum the inventory which is older than 1 year (inspection date is a separate column in 2nd sheet)

Upvotes: 1

Views: 597

Answers (1)

player0
player0

Reputation: 1

sum B column older than year:

=SUMIF(A2:A, ">"&DATE(YEAR(TODAY())-1, MONTH(TODAY()), DAY(TODAY())), B2:B)

0

sum stuff between two dates:

=SUMIFS(B2:B, 
 A2:A, ">"&DATE(YEAR(TODAY())-1, MONTH(TODAY()), DAY(TODAY())), 
 A2:A, "<="&TODAY())

0

Upvotes: 2

Related Questions