Help with formula: average productivity in different production lines.

Amund Behrns

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.. :)

Chris Mondeau

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!

Chris Mondeau

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!