Excel Database Functions - BETTER than SUMIFS, COUNTIFS etc.!

0:00 Introduction
0:22 Database Function Syntax
1:27 Database Function Example - Multiple AND Criteria
3:33 Database Function Example - Multiple AND OR Criteria
4:22 Database Function Example - Multiple OR Criteria, Same Field
4:52 Database Function Example - Multiple OR Criteria, Different Field
5:45 Database Function Example - Wildcards
6:39 Database Function Example - DGET Function
7:37 Database Function Rules

CAUTION: The multiple OR criteria on different fields example (4) will aggregate all data which is level 1, including level 1 for Atkins (because the name field is blank on the first criteria row), plus all other levels except those that are for Atkins (because the Type field is blank on the second criteria row). Caution: it will double count Level 1 not equal to Atkins and this is probably not what you want.

[lodingwai]

Thanks for sharing this! I've seen these "D" functions around and have been using Excel for years (for work) without being curious enough to look into them (getting by with SUMIFS and COUNTIFS etc). Now I can add one more tool to the Excel toolbox - thanks again!!

[maciejnejman]

This is great. Up to now I used some other functionalities of Excel like tables, Power Query, sumifs and similar, array formulas, advanced filtering but only heard about database functions. Now I will harness them to the work 😀

[blessedowo]

Thanks will learn this. :) I cannot express how thankful I am for your work.

[martinargimon]

Thanks Mynda. I use database functions ALL the time . I have created a whole DATA model with various tables fro my business that tracks orders, customers, invoices and so on, so the Database functions are a must., .. Nice tutorial .Hope more people start using Excel's Data Model and these functions... Regards and thanks once again for you excellent tutorials. Bye for now

[lesleywilliams]

Great video! I have never used these functions but as I watched I was thinking of all the ways I can use a number of them in my reports. Thank you!

[vijayarjunwadkar]

Very nice tutorial Mynda! Excel has so many hidden gems and thank you for getting them to us! Stay blessed! 👌👍

[darrylmorgan]

Hi Mynda!Great Run Through Of Database Functions, I Learnt These Powerful Functions While Working With Access Back In The Day...Thank You :)

[mariaalcala]

Great video! I didn’t know about those formulas until I saw your video! Thanks Mynda

[wayneedmondson]

Hi Mynda. Thanks for this great summary of these less well know and used Database functions. Thumbs up!!

[JOJO-ogqc]

the most clear and full explanation of D~ function on youtube thank you so much

[utubeAgape]

I did not know about these and will certainly think about how & when to use them - thank you for the great instruction!

[chrism]

Great video Mynda, I rarely use them so this was very helpful!

[rachaelhanna]

Great video, fully and clearly explains all the features and rules. Nice one .

[roywilson]

Great video. The D functions also have the great bonus of having the criteria visible so no trying to work out what has been filtered in or out of the calculation. I also love the advanced filter for the same reason.

[bulliethepirate]

Clearly explained and well presented. Thank you very much for this.

[diannedrechsler]

Very useful! This is a lot easier than writing large sumifs with many criteria.

[mohammadj.shamim]

As usual, professor thank you very much. You are great.

[gregbernard]

Another good one, I’ll have to check these out more.

[silversolver]

Excellent, very well explained Mynda, thanks!

[jeromeastier]

Excellent! Exactly what I needed. Cheers.