You probably know how to use the MAX () and MIN () functions, to return the latest and earliest dates, respectively, in a range. But, how would you grab a corresponding value for that date?

You can use SUMIF in Google Sheets to add numbers together that are associated with a date range, specific text, or meet a numeric criterion.