One way:

=SUMIF(A1:A5,"Active",B1:B5)/COUNTIF(A1:A5,"Active")

Format as %

Biff

"Excel for Dummies" wrote in
message ...
I have a question that I hope someone can help with.

A B C

1 ACTIVE 11.88% _______ Average
2 ACTIVE 12.80%
3 ACTIVE 14.67%
4 INACTIVE 22.90%
5 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?