Oct 19, 2020 · Google Sheets is a powerful and free tool to manage complex spreadsheets. This tutorial illustrates ten useful formulas you must know to help you simplify the way you work in Google Sheets. Vertical Look Up. This formula searches for value in the left-most column of array and returns the value in the same row based on the index.

Oct 07, 2020 · If you prefer hardcoding a date range in the formula, then type a date right after the logical operator and enclose the whole criteria in quotation marks like this: =SUMIFS(B2:B10, C2:C10, ">=9/10/2020", C2:C10, "<=9/20/2020") To avoid possible mistakes, you can supply dates with the help of the DATE function: