Power Query Classic COUNTIFS | SUMIFS | AVERAGEIFS | MAXIFS | MINIFS Calculations [Simply Amazing]

In this Excel video, I covered how to create COUNTIFS, SUMIFS, AVERAGEIFS, MAXIFS and MINIFS calculation using Power Query and Worksheet Functions. If you enjoy this video: Like | Share | Comment and consider SUBSCRIBING for more videos
#microsoftexcel
#excel
#sumifs
#powerquery
#powerbi

[@kapildevrana351]

This is nice summary with power query with all function explained very well.

[@dasaradhichenji2961]

great video. I was looking for this solution. thanks a ton.

[@Abioladavid01]

Glad you found it useful

[@daschenji]

Such a great video, I wish to press the like button 100 times

[@nelsoneng208]

Amazing, thank you!!

[@alterchannel2501]

Amazing top tutorial

[@phoolkhan87]

Amazing.....to the point
It's simply perfect

[@Abioladavid01]

Thanks

[@LuisCarlosChavez717]

I loved this tutorial so much! It was amazing and extremely helpful for my daily work. I learned a lot of new things and I can't wait to apply for them. Thank you for sharing your knowledge and skills with us!

[@Abioladavid01]

Glad to hear that the tutorial was helpful 😃

[@wascheidel]

Very well done Sir!

[@sayaligawade7782]

That's it....u covered most required functions in Excel

[@FRANKWHITE1996]

Thanks for sharing 🎉

[@jennahtimbreza776]

Amazing idea. Thanks to this I can now incorporate the MAXIFS portion of my analysis in the PQ stage instead of adding it after loading the table.
Subscribed!

[@Abioladavid01]

Good to hear that the video is helpful 🤠

[@TheZaynabKareem_]

This is so helpful🙏 I've been stuck on a project for a while. This is the video I've been looking for that would help me complete it. Thank you! 😭

[@martyc5674]

Great content Abiola David - subscribed!!

[@Abioladavid01]

Thanks for your comment and subscribing

[@KennedyMateko]

Benefited immensely from the great Power Query /Excel tutorial. Thank you

[@Abioladavid01]

Glad to hear this 🤗

[@XenArena]

Epic!❤

[@SamehRSameh]

Great 🌹
We need more about M language

[@seregv]

Simply ingenious! This helped me a lot.

[@jimayas]

Excellent execution David!
Subscribed for sure!

[@Cthames123]

Great solution and explanation. I liked and subscribed and will be checking out your other videos!

[@oscarsantanafernandez5719]

Excellent video! Thank you so much!

[@Abioladavid01]

Thanks Oscar!

[@heeren.9]

Great Sirji. Subscribe.. I got amazing ideas to reduce my Problem using PQ..
Plz Continue more videos sir..

[@Abioladavid01]

Glad to hear that this video is useful to make you awesome in Excel PQ

[@joshcastonguay9491]

You rock Abiola!

[@Abioladavid01]

Thanks Josh

[@yashshah9000]

Life saver. Thanks

[@usmaniqbal1836]

Abiola Super! Please aslo share data for practice, request

[@MrDhunpagla]

Awesome Mr David 👌👌 Where have you been Man 🤗🤗🤗 Great tutorial...Thanks a TON

[@Abioladavid01]

Thanks buddy 😘

[@IvanCortinas_ES]

Terribly good. Another wonder of Power Query. Thank you my friend!!

[@Abioladavid01]

Thanks for your beautiful comment and support

[@boissierepascal5755]

Génial !!!

[@tomaszmatoga305]

David rocks!

[@Abioladavid01]

Thanks Tomasz

[@ovoogbewe6967]

Hi Abiola, thanks for the tutorial. I have one questions though. Using the Skrillz Payment as example. I can see it has more than one brand associated with it. When you removed duplicates it brings back only one brand associated with Skrillz. I would like to count all the brands and not one.

[@davidmedina5411]

Thank you for this. I've trying but the the query did take too long to retrieve the info. is there any way to optimize the process?

[@michaelfrandsen6732]

Super nem forklaring

[@NhungNguyen-ho5op]

I would like to ask which way has better performance optimization? between writing M language as you did and merge query function?

[@Abioladavid01]

Thanks for the question. I believe writing the M language, although more technical, is better than using the merge query button because it helps to understand the M code.

[@mahamohan1]

Crisp explanation. However, demo files are required for practice, for a learner

[@mohamedhelmyibrahim8722]

One question please, if I need to have sumif from two queries in the same custom column, I have tried to use + and &, but it didn't work, so can you please help me in this, thank you so much

[@vamaveche09]

David, these codes work great for 2 arguments, how about more than 2 arguments, I tried with "and" and does not work, it gives an error. Are there any tricks?

[@keithwong8144]

Great Video. I had 1 question. For the List.Max and List.Min , how can i get the Max or Min value with a condition (For example, get the max value witin that list that is lesser than 100) or get the MIN value within that list that is lesser than 50
do i just add a "

[@Lyriks_]

You are so good, i'm wondering why you weren't invited in GES2022 ? 🤔

[@Abioladavid01]

Thanks for your comment

[@hudzaifahhudzaifah-zv6yw]

Thank you bro. I have try your tutorial in my 23000 rows excel workbook, but getting very long time to load the query. How i fix it?

[@Abioladavid01]

Thanks for watching my video. Maybe the processing speed of your laptop is relatively small hence, taking much longer time to load

[@hudzaifahhudzaifah-zv6yw]

@@Abioladavid01 My Laptop use intel i5 gen 12 type H and 16gb Ram. Is enough tu run the code?

[@TheKhaykeo]

Dear Sir, Why the function (MyVariable) dos't work for me. it show me as (The name 'MyVariable.Value' wasn't recognized). I need to use this function to solve my works.
Help me and advice please.
Thank you.

[@gjwilliams4098]

Curious question...couldn't this have been achieved by grouping?

[@Abioladavid01]

Good question. It can certainly be achieved by grouping. However, doing it that way doesn't add the taste of having to write the M code just like writing code in Python and other programming languages 🤠

[@sakibzamanmohammad8895]

How to do sumif if u extract the data from a CSV file brother.

[@Abioladavid01]

The same process. Just that you won't need to use the and logical operator if you're doing SUMIF

[@احمدفايز-ه3ح]

I'm need equation countifs in rows Instead of columns in power query
Plz

[@احمدفايز-ه3ح]

؟؟

[@cristianlopez1988]

umm el video simplemente se solventa con un Group by.

[@shyamdesai8944]

Please share the demo file. thank you

[@М.ЦветковВиденов]

This video doesn't show how to add conditions to the conditional formula.

[@jiquandeng7110]

When the records more than 10000，it takes too long time