Database formulas

[imalina]

Hello,

I have this problem that is bugging me because I can't figure out how it's done.
I know it is something simple, but for some reason I cannot find the answer on google. It's probably because english is not my native language, so I don't really know what to google. I tried and I tried to google anything related to this, but it did not answer my question.

So the problem is very easy: I have a table, a database, for which I need to count the number of employers, based on a criteria.
This would be very easily done with a DAVERAGE.
However, I need to display the average by city.

I have this already solved in my file, I just can't figure out how it was done and I can't replicate it.
Please see the screenshot.
I understand the DAVERAGE formula; I know that I have to press CTRL+SHIFT+ENTER, cause it's an array formula;
The 3 cells on column C are the cities from the table and the cell marked with blue on column A is the column name of the cities.
Do I put the cities there manually (copy paste the entire column, remove duplicates?) or how did they get there?
I know it has something to do with having the column name of the city there as criteria, I just can't figure out how.

A4:H25 is the database, A4 is the first column name.

excel2.PNGexcel1.PNG

So I can you help? I know it's something really stupid.

Thank you,
Alina

[queuesef]

I'm hoping this website will help you....by way of example. https://www.tutorialspoint.com/advan...e_function.htm
Normally, if I could see your entire example, i would show you my results.....but this should hopefully help.

[imalina]

Hi,

It does not help me, this is an example where the database formula returns ONE result.
I need to have the DCOUNT (sorry, I got confused, it was DCOUNT, not DAVERAGE) spread by cities.
Again, This is already done in the file, I just don't understand how it was done.

I am attaching the file.

[janmorris]

it is a "Data Table".

you can create a data table by going to the "Data" tab, then clicking the down arrow of "What-if-Analysis", then selecting "Data Table..."

what-if-analysis.png

data-table.png

see here for more info:

https://support.microsoft.com/en-us/...2-77542a5ea50b

https://www.excel-easy.com/examples/data-tables.html

[imalina]

YES! THANK YOU!
I did it! I knew it was something simple, but I had no idea what to search for.

Thank you so much!