Haven't you asked this already? And been given several (very similar)
answers?

One way:

Array Enter (CTRL-SHIFT-ENTER or CMD-RETURN):

=AVERAGE(IF(B1:B1000="Active",A1:A1000))



In article m,
wx4usa wrote:

Average IF? A1:A1000 has numbers - B1:B1000 has Active or Inactive.
How do I run an average of column A's numbers that correspond to
column B's active?

25 Active
34 Active
60 Inactive
20 Active
65 Inactive
90 Active