Home

Average formula

Highlighted
nevans1283
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
Highlighted
If your range is Column B, you may use this formula:
=AGGREGATE(1,6,B:B)
Related Conversations
Leap year formula
Hattsoff in Excel on
4 Replies
FORMULAS
aayushman_mishra in Excel on
4 Replies
formula for data calculation
aayushman_mishra in Excel on
10 Replies