MITTELWERTWENN Funktion in Excel ganz einfach

In this tutorial, I'll show you how to use the AVERAGEIF function. This allows you to specify a range you want to filter. The average can then be calculated from the filtered range for a column you specify. I'll show you how to do this first, where the data is entered directly in the formula, and then how to use another cell to enter the data for the filter. This makes the whole thing much easier to use. Formulas used for the AVERAGEIF function in the tutorial: Make sure your table structure is the same when using the functions. Of course, an entry in cell D1 is required to set the filter. =AVERAGEIF(A2:A11;D1;C2:C11) An easy-to-understand tutorial for beginners in the field of: Excel. You can also find many more tutorials and downloads on my website: https://toptorials.com This guide/learning video is in German. #excel #excel365 #tutorial