Hi
try the following array formula
=AVERAGE(IF(A1:A100="DG",B1:B100))

--
Regards
Frank Kabel
Frankfurt, Germany

"Wynn" schrieb im Newsbeitrag
...
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!