Using AVGW(COLLECT and still missing the mark
We would like to caluclate a weighted average for the total number of projects our Project Leads manage. I tried using AVGW(COLLECT to total the weights assigned to their projects with the formula below, but received an Incorrect Argument error. (The IMs column is calculating their total projects)
The way we are assigning weights may be the problem; currently weights are assigned for each project and anticipated months of work to help track Lead capacity. Would we need to first calculate each Lead total to use in the AVGW function?
Answers
-
@Tina Rustvold, based on how your sheets are structured, try this...
= SUM(COLLECT({Monthly Weight}, [IM Lead]:[IM Lead], @cell)) / IMs@row
The formula takes the sum total of the project monthly weights, and divides it by the number of projects to attain your average project weight.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!