Thread: Formula Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Excel for Dummies Excel for Dummies is offline
external usenet poster
 
Posts: 4
Default Formula Help

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?