Excluding Zeros from an Average Formula
Hello,
I am creating a simple dashboard showing the average percent complete for a portfolio of projects. We have now decided to carve out those projects not yet started (0% complete). How do I edit my formula to carve out those projects that are at 0% complete?
=AVERAGEIF({Information Technology Business Plan Range 2}, "Transit Information Program", {Information Technology Business Plan Range 3})
Thanks!
Answers
-
Hi @Stacey Gerhardt!
Here's a couple options for you:
AVERGAGIF() is a good option if there's only one criteria you're trying to meet, like excluding zeros. If you want to exclude more values, then using the AVG() and COLLECT() formulas together can help you get more options.
Let us know if that helps, thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!