Entered as an array using the key combination of CTRL,SHIFT,ENTER (not just
ENTER):

=AVERAGE(IF((A1:A7="Active")*(ISNUMBER(B1:B7)),B1: B7))

Format as %

Biff

"Excel for Dummies" wrote in
message ...
The below formula was provided for the question below, can someone tell
me
how to add into the formula how to not include cells missing information
so
that it does take those cells into account when calculating the average in
cell C1?

=SUMIF(A1:A7,"Active",B1:B7)/COUNTIF(A1:A7,"Active")

I have a question that I hope someone can help with.

A B C

1 ACTIVE 11.88% _______ Average
2 ACTIVE
3 ACTIVE 12.80%
4 ACTIVE
5 ACTIVE 14.67%
6 INACTIVE 22.90%
7 ACTIVE 45.09%

If I wanted to get an average in cell C1 of all the cells in Column B1:B5
that read active in Column A1:A5 how would I write that formula?