Average with criteria

TorAtle Myrmel

Hi

I need some help regarding making an average.

There is multiple rows with the text "Mekanisk" in it at "System" column, and a corresponding "%" at the "Fullført" colum.

How do I make an average of all these uniqe % values?

Thank's! :)

Nick Korna

Hi @TorAtle Myrmel,

If you're after an average for all the %ages in "Fullført" against rows containing "Mekanisk" in "System" then you would use the following formula:

=AVERAGEIF([System]:[System], CONTAINS("Mekanisk", @cell), [Fullført]:[Fullført])

Example:

Hope this helps, but if you've any questions or comments then just post! 😊

Nick Korna

Hi @TorAtle Myrmel,

If you're after an average for all the %ages in "Fullført" against rows containing "Mekanisk" in "System" then you would use the following formula:

=AVERAGEIF([System]:[System], CONTAINS("Mekanisk", @cell), [Fullført]:[Fullført])

Example:

Hope this helps, but if you've any questions or comments then just post! 😊

TorAtle Myrmel

Thank you!

Nick Korna

No problem, happy to have helped!