I want to average numbers in column B, only in column A has a specific term
(in other words, an average of all rates in column B where column A contains
the word "DG").

I am figure I need to use COUNTIF, OFFSET, and AVERAGE functions, but I am
having trouble putting them together. Thanks!