Home

Average formula

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
If your range is Column B, you may use this formula:
=AGGREGATE(1,6,B:B)
Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies