Try one of these. Assuming there are no empty cells within the range:

=SUMIF(B1:B1000,"Active",A1:A1000)/COUNTIF(B1:B1000,"Active")

Or this array formula** :

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

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP


"wx4usa" wrote in message
s.com...
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