Fortunately, Google Sheets ... use the formula: =AVERAGEIF(A:A, "Groceries", B:B) Based on the sample data, the average ...