Help with formula: average productivity in different production lines.
See picture. I`m trying to find the formula too help me sort out the average productivity in different productionlines.
Can somebody help me with the right formula? I need to find the averiage "produktivitet" sorted by "Linje 1, 2 etc" and sorted by date. Referenced from the sheet below to another sheet.. :)
Best Answer
-
Hi @Amund Behrns ,
It looks like you'tr trying to use an averageif() so that you get the average time spent on the lines matching Line 1, Line 2, Line 3, etc.
If so this might be what you're looking for where we average the "Antall minutter" column for any row that matches the Linje Column.
If you the column that is averaged needs to be changed, you can adjust the column range/name. Cheers!
Answers
-
Hi @Amund Behrns ,
It looks like you'tr trying to use an averageif() so that you get the average time spent on the lines matching Line 1, Line 2, Line 3, etc.
If so this might be what you're looking for where we average the "Antall minutter" column for any row that matches the Linje Column.
If you the column that is averaged needs to be changed, you can adjust the column range/name. Cheers!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!