Average IF? A1:A1000 has numbers - B1:B1000 has Active or Inactive
There's no AVERAGEIF function, but there are SUMIF and COUNTIF functions. So,
assuming your numbers are in A1:A6, and the statuses are in B1:B6, the
formula would be:
=SUMIF(B1:B6,"Active",A1:A6)/COUNTIF(B1:B6,"Active")
--
* Please click Yes if this was helpful *
Andy Smith
Senior Systems Analyst
Standard and Poor''s, NYC
"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
|