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
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies