YTread Logo
YTread Logo

Diese Funktion ERSETZT grundlegende Excel Formeln

Mar 28, 2024
Now I've replaced 10 basic Excel functions that you probably use every day with a single Excel function. Today I would like to show you why I prefer this feature to all the others. Then I will explain how you can make optimal use of it. of this function if it suits you. So interested, I thought I would subscribe to this channel and now stay tuned. As you can already see, I have prepared some features that will completely replace my new feature and soon yours. On the one hand, here we have the minimum and maximum number of summer average.
diese funktion ersetzt grundlegende excel formeln
Below we have a sales table to be more precise with materials, other values, prices, parts and sums that we would now like to calculate and possibly build a board for example, that means that now I want to add the sum of all my products, which which means I go here and it shows the same super parenthesis i.e. all my total values, check them, press enter and have the value 3394. Now my big problem is that I want to filter something. at the bottom of my table to get a better overview of my values, i.e. I accept the filter by filter and say that I only want the Austria region to be displayed.
diese funktion ersetzt grundlegende excel formeln

More Interesting Facts About,

diese funktion ersetzt grundlegende excel formeln...

I get and press OK, we have significantly less values, but our sum is still 3,394 if you still add everything. At this point, our new feature comes into play. We remove the sum function and remove the filter for now. We go up again and say is equal to the partial result, press tab and open the brackets. here now we have the selection of functions whose partial result is completely replaced for me average number number two maximin product here still summer and some intermediate values ​​that means that now we want to form the sum, that means that I write a new one, add a semicolon and now I can mark my sums as usual, press Enter and I have my 3394 again.
diese funktion ersetzt grundlegende excel formeln
Now I want to narrow it all down to Austria again. I just use Austria, say ok and we will see the value immediately changes to 788.5 euros, which means that the partial result only calculates the values ​​that are actually displayed through a filter. In my opinion, this function is used much more often than the actual sum function, which always calculates all values. Now I can for example I also do it with an average, I clear my filters again, I write it, it equals the partial result, I put it, now I say an average instead of 9 sum and I take my full values ​​again, my 67.90 yes now I just have Austria activated again, I can get €49 25 cents everything, now I probably do everything with the number of mines and the maximum.
diese funktion ersetzt grundlegende excel formeln
Now I have filled in all the values ​​and the values ​​are all completely dynamic, meaning that no matter what region you select, for example Germany, the values ​​always change dynamically and in my opinion this is significantly better than the original functions that sum the middle number, etc., because most of the time I really want to calculate the values ​​that I can actually see, which means it doesn't help me if I have the sum of values ​​that I haven't filtered at all, which is how I personally perform my calculations the partial result is often more correct than if I use the actual values, but it is still a big caution when using the partial result function, you should always keep in mind that you are only calculating what you can see, i.e. if you take values . ​here you can filter, but still, if you don't want to film the calculation, then you can't use the function and you will only get errors.
However, in my experience I have found that when I want to stream I usually also want to have the results filtered, but I still use the partial results for values ​​that I don't filter. I just filter because I have personally gotten used to it and if I then calculate values ​​that are not filtered then it still gives me the correct result. If you've been paying close attention, you'll have seen that if I enter it right away not only do I have a partial result down here from 1 to 9 but also from ten down. to 111 which means I basically have two levels which are one level i.e. 1 to 11 take all hidden values ​​in the calculation and below 101 to 111 they do not take hidden values ​​in the calculation.
That is, if I only take the sum with the new one instead of 109, the following happens: I mark my complete total values ​​again and I get €3394, but if I now go here and say the pencil is on my table but it is not part of my type right now, which means I can hide it completely in this case, then the value here will be corrected and the pencil will not be included in the calculation. If I go in now and say instead of 109, we only see 9. The value will still be included in the calculation if I do it now.
If you show the line again, nothing changes in this case, but at 109 the value will now be added again, meaning the partial result. has significantly more flexibility in how I calculate my values ​​and what I do with them. I hope I was able to show today a function that you don't know yet and maybe you can save something in the future if you are now interested in new and better functions in Microsoft Excel, I recommend this video here where I explain the new function that completely replaces the VLOOKUP so you never have to use it again, I'm glad I was able to help you if you have.
You are not yet subscribed to the channel, consider doing so, it is free and you can change your mind at any time. I hope to see you in the next video. ciao

If you have any copyright issue, please Contact