DAVERAGE, DMIN,etc from List
 

Clueless on even if what I'm asking is possible...

I have an Excel worksheet and got the AutoFilter drop-downs, from creating a
list.
When expand the drop-down, I see:
"All", "Top 10", "Custom", the a Listing of the Items in the column...
I've got the "Total" row at the bottom, with things like: AVG, Count, Max.

I was requested to use DAVERAGE, DMIN, DMAX and DSUM functions.
I gather that is because the data in the sheet might change - although I
don't understand what the difference is.

Most importantly, how can I add the D'functions to this list?
Can/should it be added to the "list" drop-down, or can it come from the
Total fxns?

I've got about 5 columns that are supposed to have each of the D'fxns
requested above.

Thank you much for any assistance!
-TexJen

DAVERAGE, DMIN,etc from List
 

Search for "Database functions" in Excel Help menu


"TexJen" wrote:

Clueless on even if what I'm asking is possible...

I have an Excel worksheet and got the AutoFilter drop-downs, from creating a
list.
When expand the drop-down, I see:
"All", "Top 10", "Custom", the a Listing of the Items in the column...
I've got the "Total" row at the bottom, with things like: AVG, Count, Max.

I was requested to use DAVERAGE, DMIN, DMAX and DSUM functions.
I gather that is because the data in the sheet might change - although I
don't understand what the difference is.

Most importantly, how can I add the D'functions to this list?
Can/should it be added to the "list" drop-down, or can it come from the
Total fxns?

I've got about 5 columns that are supposed to have each of the D'fxns
requested above.

Thank you much for any assistance!
-TexJen