Average formula

Occasional Visitor

I need to create a formula that will average only the cells that contain a value in a range of cells.  Each of these cells contain a formula that pulls data from a different worksheet, so until those corresponding cells are populated, these cell contain "#DIV/0!". I hope that makes sense!

1 Reply
If your range is Column B, you may use this formula:
Related Conversations
Leap year formula
Hattsoff in Excel on
4 Replies
aayushman_mishra in Excel on
4 Replies
formula for data calculation
aayushman_mishra in Excel on
10 Replies