How to apply slicer on formulas in MS Excel

In this video, you will learn how to apply your formula only on visible cells. You can filter your data using slicers or auto filters.
But except for Subtotal and aggregate, all other MS Excel functions will consider even the data that are hidden or filtered out.
But with some additional help from the filter function and subtotal function, we can perhaps make every single MS Excel function consider only the visible cells.
In this video, I have talked about using this for Sumifs, Unique, and Filter. But you can also the same logic for other set functions such as Averageifs, Countifs, etc. You can also apply it in Xlookup, Vlookup, etc., as well in Office 365.

[@mukeshkadkol4759]

Superb boss !

[@KrishnaKumar-zn9kg]

This is a beautiful tip! I have always wanted to use slicers in summaries, and you have shown me the way to do it! Thanks a ton!

[@kunikaverma72]

Landed here from your LinkedIn post. Great timing of the video as learning advanced pivot tables is my next step! Only halfway through the video and it's so informative as always. Thank you sir :)

[@BhavyaGupta]

Superb video! Mind-blowing tips and tricks 🤯

[@dumindumudalige4397]

Love it👌

[@hdgggg]

Amazing stuff sir, thank u

[@sunnybaggu785]

Hii sir,, Greetings! In excel, I have points or coordinates of rectangle (not in any specific order) given with its (x,y) coordinates. The available points could be in any numbers (including corner points and inline points too). Then how do I sort the coordinates and plot a rectangle in excel chart.

[@newari1111]

Hi Viz! Thank you for this! Would you mind sharing this sample file?

[@ProfectusLearning]

Sending you the raw data

[@saibhargav4236]

Do you have excel course sir

[@vishnulal2967]

Can I get that file please?

[@shraddhashah2167]

Explanation which is given in this video is quite difficult to understand, it should consist of use of simple words and cut to cut. It went out of my brain.